Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

outer join of multiple tables

3128241Nov 25 2015 — edited Nov 30 2015

SELECT * FROM

(SELECT * FROM TABLE1) a

FULL JOIN

(SELECT * FROM TABLE2) b

ON a.ID = b.ID;

and this worked. But,

SELECT * FROM

(SELECT * FROM TABLE1) a

FULL JOIN

(SELECT * FROM TABLE2) b

FULL JOIN

(SELECT * FROM TABLE3) c

ON a.ID = b.ID = c.ID;

this doesn't work.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2015
Added on Nov 25 2015
7 comments
3,439 views