Question

224 viewsMay 29, 2023Officesql-server

1

Sandhya 2.52K May 26, 2023 0 Comments

how to use the SQL Server CROSS JOIN to join two or more unrelated tables.

score 0 · Answer 1 · 2023-05-29T06:15:04+00:00

You are free to CROSS JOIN any number of tables.

Let’s expand on the exercise’s example, which featured tables for shirts and trousers, by including a third table for socks.

In total, there are 36 combinations (3 x 2 x 6), or rows.

score 0 · Answer 2 · 2023-05-26T04:54:24+00:00

You are free to CROSS JOIN any number of tables.

Let’s expand on the exercise’s example, which featured tables for shirts and trousers, by including a third table for socks.

In total, there are 36 combinations (3 x 2 x 6), or rows.

Questions