MySQL CROSS JOIN

MySQL CROSS JOIN will return all records from both tables.

MySQL CROSS JOIN Syntax

SELECT column_name(s)
FROM table1
CROSS JOIN table2; 

Example

The following example shows you how to do CROSS JOIN with tableX and tableY

SELECT  * FROM tableX 
CROSS JOIN  tableY 

You can have the following results