Joins are used to combine data from two or more tables based on a related column.

• Use JOIN keyword followed by the name of the table to join

• Specify the columns to join on using ON keyword

• Types of joins...read more

INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN

INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN