CROSS JOIN | CARTESIAN JOIN | NON-ANSI JOIN | ANSI JOIN | SQL JOIN #techpointfundamentals

CROSS JOIN | CARTESIAN JOIN | NON-ANSI JOIN | ANSI JOIN | SQL JOIN | #techpointfundamentals If two or more tables are combined with each other without any condition we call it a Cartesian or cross join. So a CROSS JOIN is a join without any condition. A CROSS JOIN does not have any ON clause. Using an ON clause on a CROSS JOIN would generate a syntax error. In CROSS JOIN, each record of a table is joined with each record of another table. The size of a Cartesian product is the number of rows in the first table multiplied by the number of rows in the second table.