ON Clause

Clause that can be used in place of the WHERE clause when explicitly stating an INNER JOIN condition (however, the WHERE clause still works). For LEFT and RIGHT OUTER JOIN clauses, however, the join condition must begin with the ON clause.