Search For

PRODUCT JOIN

Flag Hide Line Nos
Flagging a Snippet, takes the snippet to Moderator Attention;


0
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 ;


Vote! You feel this code is working like charm ? Go a head Login and Press up arrow.
Didn't work ?, press down arrow and let us know the error in comments

Comments