The CROSS JOIN keyword returns all records from both tables (table1 and table2).
MySQL CROSS JOIN
CROSS JOIN Syntax
SELECT column_name(s)
FROM table1
CROSS JOIN table2;
FROM table1
CROSS JOIN table2;
Practice Excercise Practice now