At 12:15 PM 1/10/2003, you wrote: >I would do the following > >SELECT tblShopper.shopperID >FROM tblShopper >WHERE shopperID NOT IN (SELECT DISTINCT tblOrder.shopperid FROM tblorder)
Didn't catch the original post, but you could probably to the above more efficiently with an outer join SELECT S.ShopperID FROM tblShopper S LEFT JOIN tblOrder O on S.shopperID=O.shopperID WHERE O.orderID IS NULL which retrieves all shoppers that do not have any orders--if that's not the goal here then please ignore. HTH, Sam ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4