SQL Cross means cartesian product of the rows of two or more tables . It return all the rows of the table when each row of the first table combined with the each row of the second table . It is also known as cartesian or cross join . Cross Join can be represent by two ways :
1) Using Join Syntax .
2) from clause without using a where clause .
Syntax :
select * from table1 cross join table2 ;
or
select * from table1 , table2 ;
Example of Cross join : First Table name : Employee_Info
0 Comment(s)