SQL SERVER – Introduction to JOINs – Basic of JOINs

CROSS JOIN

This join is a Cartesian join that does not necessitate any condition to join. The resultset contains records that are multiplication of record number from both the tables.

SELECT t1.*,t2.*

FROM Table1 t1

CROSS JOIN Table2 t2