Explicit join condition in Teradata

The "explicit join notation" uses the JOIN keyword to specify the table to join, and the ON keyword to specify the predicates for the join, as in the following example:

SELECT *
FROM employee
INNER JOIN department ON 
employee.DepartmentID = department.DepartmentID;