Thanks for the concise answer and suggestion. We have an in-house tool (similar to the redgate product) that matches up schemas. I was more interested in the data. For those...

I never realized that the WHERE operated after the JOIN....aaargh!  I've been doing those hideous concantenation NOT IN operations for years...

Thanks man;

The NOT EXISTS does not work, but option 2 (LEFT JOIN with a check NULL) does.  The only issue, which is minior, is to make sure that whaterver column...