The INNER JOIN Clause

Combines records from two tables whenever there are matching values in a common field. The join is specified in the FROM clause. The syntax is:

FROM table1 INNER JOIN table2 ON table1.field1 comparison-operator table2.field2