what is cross join

Cross Join:-
Cross join is used to return all records where each row from first table is combined with each row in second table.
cross join is also called as Cartesian Product join.
Sql Cross Join Syntax:-
Select * FROM TABLE 1 CROSS JOIN TABLE 2
OR
Select * FROM TABLE 1, TABLE 2