1. Self Join-when u need to join a table to
itself
2 Equi Join:-The relation between the
employee table and dept table is an equi join that both tables must be equal
3.Non equi Join:-The relationship is obtained
using operator other than = operator.
4.Outer Join:-The missing rows can be
obtained is outer join operation is used.It returns rows from one table that
have no direct match in other table.
5.Cross Join:-produces cross product of two
tables.
6.Natural Join;-It is based on all columns in
two tables that have same name or same column.
7.Inner Join-To find out only matched
columns.
8.Full outer join:-inner join+left outer
join+right outer join
