(this is SQL7 btw) Got an odd issue and I'm not 100% sure how to tackle it.
I have two tables, linked by a pair of values. Querying to get all the records out of the first table where I find a record in the second table, with certain IDs and a certain value in a field, no sweat. Doing that with a right outer join. Doing multiple second-table checks like this is also no problem. Now I'm trying to figure out something of the opposite - where a value in the second table is NOT what I'm checking on. My issue is, I don't have a record in the second table with the ID criteria from the first table, for every record in the first table. So what I need to do in these cases is check for either: 1) There IS a matching-ID record in the second table, and the field value of this record is not a match for my checking criteria; 2) There is NO matching-ID record in the second table at all, hence no value to check against (which means this record would qualify) Any nudges in the right direction would be most appreciated. Thanks --Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
