Cross join

Cross join query returns all records where each row from table1 combines with all rows from table2.

CROSS JOIN can be called in two ways using JOINS and tables separated by the comma (,).

Syntax:

SELECT * OR column_name(s)
FROM table1 t1
CROSS JOIN table1 t2

(OR)

SELECT * or column_name(s)
FROM table1 t1, table1 t2

Example:

SELECT * FROM tbl_Employees E  

CROSS JOIN tbl_Employees E1

Result