Explicit join condition in Teradata

  1. Forget Code
  2. Teradata
  3. Explicit join condition
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;