PRODUCT JOIN in Teradata

It is a Teradata specified Join, which is used as equivalent to product join.
There is no “On” clause in case of CROSS/PRODUCT join.

Example:
SELECT  EMP.ename , DPT.Dname
FROM     employee EMP
CROSS JOIN
Department DPT
WHERE
EMp.deptno = DPT.depto ;