Ms Sql Cross Join. So, if there are rows in customers that do not have matches in orders, or if there are rows in orders that do not have matches in customers, those rows will be listed as well. I'm not sure about what do want to accomplish, but the syntax for a full cartesian product (cross join) is select * from table1, table2.

When you run the script it will look like figure 4: Also, a cross join might be used to generate a lot of test data. Select * from customer cross join tblorder where customer.custid=tblorder.custid.