Hi,
This was a brilliant article, highlighting something I've never thouht of before. Thumbs up!
But I have a follow up question: How do you suggest that I write a query that pulls out a specific row? Let's say, all rows for a specific customerId or details for only one sales order.
It seems to me as if an inner join syntax is better in that case.
You can use inner join or subquery. please look at the execution plan and see which is good for you.