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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3278 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
