Inner Join, Outer Join, Left Inner Join, Right Inner Join Inner Join - Returns a table with common columns from both the tables with all records/rows. Left Inner Join - Returns a table with common columns from both the tables and all the columns from the left table with every row/record. Right Inner Join - Returns a table with common columns from both the tables and all the columns from the right table with every row/record. Outer join - Joins the two tables returning all the columns and rows of both the tables.