Skip to Main Content

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!

Joining multiple tables

706043Dec 23 2009 — edited Dec 23 2009
Hi All,

I am trying to figure out the layout for joining 5 different table.
Do I have to put that in a subquery and where so i start selecting the columns : at the begin meaning selecting all colmuns at the top or before each join statement for that particular table before joining them.
And what is the best structure to optimize it.....thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 20 2010
Added on Dec 23 2009
6 comments
711 views