CROSS JOIN in Teradata

Cross join is a Teradata specified join which is equivalent to Product join.
There won't be "ON" keyword in Cross joins.

Syntax (Sample):
SELECT tbl1.name, tbl2.name
FROM
table1 tbl1
CROSS JOIN 
table2 tbl2
WHERE <Condition>;


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