In Microsoft SQL Server, there are two join functions for performing a cross join, CROSS JOIN and CROSS APPLY. A CROSS JOIN creates all permutations (i.e., a cartesian product) of the two joining ...