Joins Types 1) Inner join or join (by default it will do inner join between two table) - Fetch only matching records 2) Left Outer join or Left Join - Fetched matching records and all records from Left table 3) Right Outer join or Left Join - Fetched matching records and all records from Right table 4) Cross Join or Cartesian Join -> It will give all possible combination between two table.