SQL JOIN

The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables.
Tables in a database are often related to each other with keys.

SYNTAX :

SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern;