**\(INNER\) JOIN**
- : Returns records that have matching values in both tables
- LEFT (OUTER) JOIN : Return all records from the left table, and the matched records from the right table
- RIGHT (OUTER) JOIN : Return all records from the right table, and the matched records from the left table
- FULL (OUTER) JOIN : Return all records when there is a match in either left or right table