how to use the SQL Server CROSS JOIN to join two or more unrelated tables.
Shathana. S.R. Answered question
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.
Shathana. S.R. Answered question
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.
Vishalini.R Answered question