What is the use of Cross Join in SQL?
The CROSS JOIN is used to generate a paired combination of each row of the first table with each row of the second table. This join type is also called a cartesian join.
The CROSS JOIN in SQL will Illustrate like the below syntax:
SELECT Column_1, Column_2, Column_N FROM [Table_1] CROSS JOIN [Table_2]
Or we can use the following syntax instead of the previous one. This syntax does not include the CROSS JOIN keyword; only we will place the tables that will be joined after the FROM clause and separated with a comma.
SELECT Column_1, Column_2, Column_N FROM [Table_1],[Table_2]
The following query will join the Course and Location table with the CROSS JOIN keyword and we will obtain all of the paired combinations of the Course and Location names.
SELECT * FROM Course CROSS JOIN Location
What is the use of Full Join in SQL?
What are the properties of a transaction in SQL?
Which is not the properties of a transaction in SQL?
What is the use of Session Control Statement(SCS) in SQL?
What is the use of the Transaction Control Statement(TCS) in SQL?