-
Recent Posts
- Registration is open for PASS Data Community Summit! 2022/04/05
- Intelligent Query Processing Session Follow Up 2020/11/16
- Move a VM with Azure Resource Mover 2020/09/24
- Build Your Brand Presentation 2020/08/18
- Azure Data Studio Notebooks and SQL Prompt 2020/06/04
Categories
- Cloud computing (1)
- Database Administration (7)
- High Availability (1)
- Internals (1)
- Life in IT (32)
- Security (2)
- SQL Server 2016 (3)
- SQL Server Administration (5)
- SSIS (6)
- SSRS (8)
- T-SQL (12)
- T-SQL Window Functions (12)
- Uncategorized (26)
Aunt Kathi's SQL Server Home 
I am working through “Beginning T-SQL 2012”, exercise 5-2-6 is “Write a query that returns the BusinessEntityID column from the Sales.SalesPerson table along with every ProductID from the Production.Product table”. The supplied answer uses a cross join, how would I know that a cross join is needed here?
The key word here is “every”. If I want to join from one table to every row in another table, that is a clue to use cross join.