SQL Join

In SQL, the keyword join (often JOIN) indicates the combining of records from two tables.

Syntax

The general syntax is:

SELECT column-names
 FROM table-name1 JOIN table-name2 
 ON column-name1 = column-name2
 WHERE condition