Lecture Progress:

Lecture Overview

Joins are used to retrieve data from multiple tables and combine the data from multiple tables in one row.

following are the different JOIN types that can be used in the select statement: 

1.Inner join

2.Left Join

3.Right Join

4.Full Join

5.Self Join

Quick Reference:

  • Joins require tables to have common attributes to allow combining data from multiple tables in one row format.