This join produces the Cartesian product of the two tables.
Select emp-name, dept-name
From emp
Cross join dept ;
The above example will display the Cartesian product of the two table emp and dept.
The example given below will give the same result as the above.
Select emp-name, dept-name
From emp, dept ;
Silan Software is one of the India's leading provider of offline & online training for Java, Python, AI (Machine Learning, Deep Learning), Data Science, Software Development & many more emerging Technologies.
We provide Academic Training || Industrial Training || Corporate Training || Internship || Java || Python || AI using Python || Data Science etc