scarydba.com
Database Fundamentals #22: Using the Join Operator, CROSS JOIN - Grant Fritchey
While the CROSS JOIN is not used much, and, depending on the size of your data it can be dangerous, there are some uses for it. For example, you may want to write a query that will summarize all the sales for the companies and people in your system. You can do this using what …