Re: Outer Joins

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Can someone explain why cname and date from table c gets printed in this
> query?

Say what?

test=# CREATE TABLE a (id INTEGER, name TEXT, aname TEXT);
CREATE
test=# CREATE TABLE b (id INTEGER, name TEXT, bname TEXT);
CREATE
test=# CREATE TABLE c (id INTEGER, name TEXT, cname TEXT, date DATE DEFAULT
test(# CURRENT_DATE);
CREATE
test=# SELECT * FROM a FULL OUTER JOIN b USING (id);
 id | name | aname | name | bname
----+------+-------+------+-------
(0 rows)


            regards, tom lane