Well, MINUS is Oracle. NOT EXISTS is SQL7 (which I mentioned was the case, right off *grin*)
So I'm looking at the docs for this... but I still have an issue - I need to check both cases - 1) second record exists but field value doesn't match, and 2) second record doesn't exist at all. Not sure how to do BOTH checks without them possibly cancelling each other out or interfering with each other, or other checks (I could have up to three of these type checks). At 01:18 PM 2/6/2003 -0500, you wrote: >Look into the MINUS set operator (the opposite of UNION). > >That may steer you in the right direction... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 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
