EQUI JOIN in Teradata

An equi-join is a specific type of comparator-based join, that uses only equality comparisons in the join-predicate. Using other comparison operators (such as <) disqualifies a join as an equi-join.

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