SQL CROSS JOIN
SQL CROSS JOIN returns a result set which is the number of rows in the first table multiplied by the number of rows in the second table if no WHERE clause is used along with CROSS JOIN
Home ยป
Cartesian product
SQL Server JOINS
A JOIN clause is used to combine two or more related tables. Tables are related to each other using foreign key constraints.