SQL Joins

You will get vast amount of data/ information on this page regarding Oracle SQL JOINS like

1. Example of Simple SQL Join


2. SQL Outer Join


3. Example of SQL Outer Join


4. SQL Inner Join


5. Example of SQL inner Join


6. SQL Self Join


7. Example of SQL Self Join


8. SQL Cross Join


9. SQL Equijoin


10. Join using MULTIPLE TABLES

You will get good information on Joins from the book Effective Oracle by Design by Thomas Kyte

http://www.amazon.com/Effective-Oracle-Design-Osborne-ORACLE/dp/0072230657

If you are interested in DBMS Normal forms Please go to

http://www.bkent.net/Doc/simple5.htm

Here you will find an article on DBMS Normal forms named "A Simple Guide to Five Normal Forms in Relational Database Theory" which you will surely find useful.