• Home
  • SQL Cross Join

    Cross Join:

    This join produces the Cartesian product of the two tables.

    Example:

    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.

    Example:

    Select emp-name, dept-name
        From emp, dept ;
    

    About the Author



    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





     PreviousNext