Cross join - DotNet and DataBase

Wednesday, 1 August 2018

Cross join




Cross join query returns all records where each row from table1 combines with all rows from table2.
CROSS JOIN can be called in two ways using JOINS and tables separated by the comma (,).
Syntax:
SELECT * OR column_name(s)
FROM table1 t1
CROSS JOIN table1 t2

(OR)

SELECT * or column_name(s)
FROM table1 t1table1 t2


Example:
SELECT * FROM tbl_Employees E  
CROSS JOIN tbl_Employees E1

Result
crossjoin

No comments:

Post a Comment

x

Get Updates On

Discussion updates

Straight Into Your INBOX!

Enter your email address to subscribe to this website and receive notifications of new posts by email.