T-SQL Tutorial

T-SQL Table Joins


  • Inner Join - returns rows from two tables when a match is found.
  • Left Join - returns all rows from the left table, even if there are no matches with the right table.
  • Right Join - returns all rows from the right table, even if there are no matches with the left table.
  • Self Join - is used to join a table to itself.