Home›SQL›MySQL Cross Join

MySQL Cross Join

March 31, 20191 min readUpdated 1/19/2021

 

The CROSS JOIN is used to join all rows from one table to all rows of another table.

SELECT 
    *
FROM
    table_name1
CROSS JOIN
    table_name2;