How to compare 2 columns and delete equal data

[davidg47]

Hi,

I have 2 tables that each have a column named LocationCode. The two columns have "some" data that is the same in each one, and they have some data that is unique to that column in that table.

How can I compare the data between the two columns and extract the data that is unique (not found in "both" columns)?

Thanks for your help...
David

 

[gmmastros]

Can you post some sample data and expected results? It will help us to understand the data better and probably get you acceptable advice in a more timely manner.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom