Compare 2 columns (Need help)

  • Thread starter Thread starter Christine R via AccessMonster.com
  • Start date Start date
C

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. I
My query seem to be OK, however
the results are also including the one's that are common in both columns. All
I want are the one's that are not matching in the 2 columns.
I would 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
 
have you tried using the Find Unmatched Query Wizard to build your query? if
you're not a SQL whiz (like i'm not <g>), that's the quickest, easiest way
i can think of.

hth
 
Back
Top