Re: Outer Joins

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/ ------------