Jonh,

Maybe you should use FULL OUTER JOIN and check for NULLs in the result set

Cheers,

Zoran

>I have two tables, one local (table A) and one via a remote view (table B). I want to perform comparisons of their contents using SQL select to show:
>
>1.) items in A and B
>2.) items in A but not in B
>3.) items in B but not in A
>
>I have no problem with the first, but am having touble setting up conditions for 2 and 3.
>
>Any help would be greatly appreciated!
>
>John