EQUI JOIN with USING construct in Teradata

With SQL-92 standard, you can use USING construct if the columns in an equi-join have the same name.

SELECT *
FROM employee
INNER JOIN department USING (DepartmentID);


Specifically, any columns mentioned in the USING list will appear only once, with an unqualified name, rather than once for each table in the join. In the above case, there will be a single DepartmentID column and no employee.DepartmentID or department.DepartmentID.