On Tuesday 23 January 2001 11:30, Bruce Momjian wrote:
> Can someone explain why cname and date from table c gets printed in this
> query?
The query was supposed to be:
SELECT * FROM a FULL OUTER JOIN b USING (id)
������� RIGHT OUTER JOIN c USING(id);
I missed the end of it when I was writing the email.
> > SELECT * FROM a FULL OUTER JOIN b USING (id) <-- no ';'
> > id | name | aname | name | bname | name | cname | date
> > ----+------+--------+------+--------+------+---------+------------
> > 1 | Bob | aname1 | Bob | bname1 | Bob | cname1 | 2001-01-07
> > 2 | Jim | aname2 | Tom | bname2 | Jim | cname2 | 2001-01-07
> > 9 | | | | | Tom | cname9 | 2001-01-07
> > 10 | | | | | | cname10 | 2001-01-07
> > (4 rows)
>
> ---------------------------------------------------------------------------
>
--
-------- Robert B. Easter reaster@comptechnews.com ---------
-- CompTechNews Message Board http://www.comptechnews.com/ --
-- CompTechServ Tech Services http://www.comptechserv.com/ --
---------- http://www.comptechnews.com/~reaster/ ------------