Trying to find values that are not equal

[Cindy]

Hi;
I am a new user... I have the same field in two different tables. I tried a
query to find the records where the values are not equal. I used the
expression builder but got zero records which I know is not correct. I tried
expression builder using the following:
Table_A, Field = RSL_1
Table_B, Field = RSL_1 =>There is a right join only from table A to B (I
only want to see the unequal values in Table A)

I entered the following select query criteria under RSL_1, Table_A
<>[Table_B]![RSL_1]. I also tried 'Not Like' instead of <> and got no
records for either. Does anyone know what I'm doing wrong?
Thanks!

 

[Jerry Whittle]

Select *
From Table_A
Where RSL_1 Not In (Select RSL_1
From Table_B) ;

Or in query design view put the following in the criteria of the RSL_1 field:

Not In (Select RSL_1 From Table_B)

If you want to see the opposite results, switch the table names.