Different Types of SQL JOINs (INNER) JOIN: Returns records from both tables that have matching values.
LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
RIGHT (OUTER) JOIN : Returns all records from the right table, and the matched records from the left table.