JOINS

=>    Join is a data retrieval operation. This operation is performed to get data from multiple tables.

Types of JOINS:

(i) EQUI JOIN or INNER JOIN
(ii) NON EQUI JOIN
(iii) SELF JOIN
(iv) OUTER JOIN
    a)    LEFT OUTER
    b)    RIGHT OUTER
    c)    FULL OUTER
(v) NATURAL JOIN.  
(vi) CROSS JOIN.