Re: [GENERAL] Outer Joins

[Tom Lane]

Bruce Momjian <[EMAIL PROTECTED]> 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