JOINS are used to retrieve data from multiple tables in a single query.
A relational database consists of multiple related tables linking together using common columns, which are known as foreign key columns.
MySQL supports the following types of joins:
- Inner join
- Left join
- Right join
- Cross join
