Comparing two columns to filter out un-common values................please help

[Christine R via AccessMonster.com]

Hi,
I am trying to compare two columns in a table where I can filter out the
names that are not matching with the other. My query seem to be OK, however
the results are also including the one's that are common in both columns.
I woul really appreciate a help here.
My query is:
SELECT EC_Results_compare.Results_Wellnames, EC_Results_compare.EC_Wellnames
FROM EC_Results_compare LEFT JOIN EC_Results_compare AS EC_Results_compare_1
ON EC_Results_compare.EC_Wellnames = EC_Results_compare_1.Results_Wellnames
WHERE (((EC_Results_compare.Results_Wellnames)<>[EC_Results_compare]!
[EC_Wellnames]));

Many thanks
Christine

 

[Jeff Boyce]

Christine

One possibility would be to write a query for those that DO match, then find
the rows not in that list.

Another potential issue ... if you have two columns in the same table
holding the same kind of data (i.e., names), your data structure might
benefit from further normalization.