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