Cross Join


Prev Tutorial Next Tutorial

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.

cross join

Syntax

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

Employee table

Emp_idName
101Amit Sukla
102Rahul jain
103Sultan Alam
104Hitesh Kumar

Payment table

Payment_idSalary
10120000
10245000
10450000

Example

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

Result after execute above query.

Emp_idNamePayment_idSalary
101Amit Sukla10120000
102Rahul jain10120000
103Sultan Alam10120000
104Hitesh Kumar10120000
101Amit Sukla10245000
102Rahul jain10245000
103Sultan Alam10245000
104Hitesh Kumar10145000
101Amit Sukla10350000
102Rahul jain10350000
103Sultan Alam10350000
104Hitesh Kumar10150000

Prev Tutorial Next Tutorial

Advertisements
z
Download Projects

Advertisements

Download WhatsApp Status Video

Buy This Ad Space Only $50 per Month, Ad Size 300X250 Contact on: [email protected] WhatsApp no. 8882538826

Google Adsense Advertisements