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