MySQL Cross Join

 

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

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SELECT
*
FROM
table_name1
CROSS JOIN
table_name2;
SELECT * FROM table_name1 CROSS JOIN table_name2;
SELECT 
    *
FROM
    table_name1
CROSS JOIN
    table_name2;

 




Subscribe To Our Newsletter
You will receive our latest post and tutorial.
Thank you for subscribing!

required
required


Leave a Reply

Your email address will not be published. Required fields are marked *