Displaying Data from Multiple Tables

Obtaining Data from Multiple Tables :



Types of Joins :

• Joins that are compliant with the SQL:1999 standard include the following :

1. Cross joins
2. Natural joins
3. USING clause
4. Full (or two-sided) outer joins
5. Arbitrary join conditions for outer joins

Joining Tables Using SQL : 1999 Syntax

• Use a join to query data from more than one table

SELECT table1.column, table2.column FROM table1 [NATURAL JOIN table2] | [JOIN table2 USING (column_name)] | [JOIN table2 ON (table1.column_name = table2.column_name)]| [LEFT|RIGHT|FULL OUTER JOIN table2 ON (table1.column_name = table2.column_name)]| [CROSS JOIN table2];