>On 2/10/2010 7:29 AM, Ian Skinner wrote: >> That may need to be an LEFT OUTER JOIN > >Never mind, LEFT JOIN and LEFT OUTER JOIN are the same thing, I really >need to get more sleep at night, and|or drink more caffeine in the morning.
Yeah, I think what it boils down to is that the UserID = X filter needs to be done *before* the join occurs. And I don't think that can happen without using a subquery. I'll write this as a table-valued function in SQL Server, that will allow for code reusability, and I don't see any performance problems with the subquery. I think I was pushing for a join because they can look more elegant or efficient at first glance. :) Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3279 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
