Cross Join

Cross Join

Cross Join is a the Cartesian product of two or more than two tables that is m number of rows in 1st table and n numbers of rows in 2 nd table then you will get the result of m x n.

	
SELECT * FROM Table-1 CROSS JOIN Table-2  
OR  
SELECT * FROM  Table-1 , Table-2 

Employee table

Payment table

	
SELECT * FROM Employee CROSS JOIN Payment  
OR  
SELECT * FROM  Employee , Payment 

Result after execute above query.