6. JOINS
• Purpose Of JOINS
• Types of JOINS
Cross join
Equi join
Inner Join
Self Join
Outer joins
left Outer join
Right Outer join
Full Outer join
INNER JOIN
SELECT columns
FROM table1
INNER JOIN table2
ON table1.column = table2.column;
LEFT OUTER JOIN
SELECT columns
FROM table1
LEFT JOIN table2
ON table1.column = table2.column;
RIGHT OUTER JOIN
SELECT columns
FROM table1
RIGHT JOIN table2
ON table1.column = table2.column;
FULL OUTER JOIN
SELECT columns
FROM table1
FULL JOIN table2
ON table1.column = table2.column;
