Re: Outer Joins
От | Robert B. Easter |
---|---|
Тема | Re: Outer Joins |
Дата | |
Msg-id | 0101271913560W.08820@comptechnews обсуждение исходный текст |
Ответ на | Re: Outer Joins (Bruce Momjian <pgman@candle.pha.pa.us>) |
Список | pgsql-general |
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/ ------------
В списке pgsql-general по дате отправления: