If you have m rows in table T1 and n rows in table T2, the result of a cross join between T1 and T2 is a virtual table with m x n rows.
- 4. Combining Sets
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
The CROSS JOIN does not use a key. It takes every row from 1 table replicates it with every value from the other table.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/20422/