Oracle Joins Tutorial

A nice tutorial that explains how to use joins in Oracle with both new and old syntax, visual illustrations, and examples.

http://www.techonthenet.com/oracle/joins.php

There are 4 different types of Oracle joins:

• Oracle INNER JOIN (or sometimes called simple join)
• Oracle LEFT OUTER JOIN (or sometimes called LEFT JOIN)
• Oracle RIGHT OUTER JOIN (or sometimes called RIGHT JOIN)
• Oracle FULL OUTER JOIN (or sometimes called FULL JOIN)