I would do the following SELECT tblShopper.shopperID FROM tblShopper WHERE shopperID NOT IN (SELECT DISTINCT tblOrder.shopperid FROM tblorder)
Not sure what DB your using but using a NOT and or a DISTINCT can slow performance. Also your distinct appeared to be in the wrong place, I am guessing the tblShopper.shopperid is unique so a DISTINCT there will not help you, however using it in the subquery makes sense since a sopper could have multiple orders. Truthfully though you could eliminate it from the subquery as well. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
