hai guys different type of joins are 1) self join 2) equijoin 3) non equijoin 4) cross join 5) natural join 6) full outer join 7) outer join 8) left outer join 9) right outer join
types of join:1.Self Join-when u need to join a table to itself2.Equi Join:-The relation between the employee table and dept table is an equi join that both tables must be equal3.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.
