Home
E-mail Us
Oracle Articles
New Oracle Articles

Oracle Training
Oracle Tips
Oracle Forum
Class Catalog

Remote DBA
Oracle Tuning
Emergency 911
RAC Support
Apps Support
Analysis
Design
Implementation
Oracle Support

SQL Tuning
Security
Oracle UNIX
Oracle Linux
Monitoring
Remote support
Remote plans
Remote services
Application Server
Applications
Oracle Forms
Oracle Portal
App Upgrades
SQL Server
Oracle Concepts
Software Support
Remote Support
Development
Implementation

Consulting Staff
Consulting Prices
Help Wanted!

Oracle Posters
Oracle Books
Oracle Scripts
Ion
Excel-DB

Don Burleson Blog

SQL Multi-table Joins

Multi-table Joins

Multi-table joins can become confusing and this is where the ANSI format really shines. By keeping all the join information out of the WHERE clause, it is much easier to read as the query becomes more complicated. Using the ANSI format, you can also outer join multiple tables with multiple outer joins. That was not allowed in the standard Oracle format.

SQL> select

2 author_last_name c1,

3 book_title c2

4 from

5 author full outer join book_author using (author_key)

6 full outer join book using (book_key)

7 order by author_last_name;

Author Title

------------------------- ------------------------------

clark

hester windows success

hester pay no taxes and go to jail

hester oracle9i sql tuning

jeckle piano greats

jeckle the fall of microsoft

jeckle operations research theory

jones windows success

jones never eat meat

jones was george washington feeble?

jones cooking light

mee

petty the willow weeps no more

shagger The zen of auto repair

shagger writers market

shagger bears are people too

shagger how to housebreak your horse

shagger was george washington feeble?

shagger non violins in the workplace

smith zero loss finance

smith managing stress

weaton piano greats

weaton never eat meat

weaton UNIX for experts

weaton reduce spending the republican way

withers DOS for dummies

withers never eat meat

fired - now what

the far side of the goon

29 rows selected.

In the example above, I joined three tables using full outer joins. This allowed me to include both the books without authors and the authors without books in my report. Note: I had to remove the book_keys that did not have author_keys from the book_author table for this example.

Get the Complete
Oracle SQL Tuning Information

The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher.

��