find Not matched username

[xcao]

I'm trying to compare two tables, table 1 and table 2.

to see what are matched usernames, and what are not matched.

I use following screen to pull username in table 2 which are not in table 1, but I get no records.

I know there are quite a few usernames in 2 not in 1, or in 1 not in 2.

But why the result comes to 0 records.


SELECT [2].SkyUsername
FROM 2
WHERE ((([2].SkyUsername) Not In (select adusername from 1)));

Table1:
AdUsername, AdFirstname, Adlastname
Table2:
SkyUsername, SkyFirstName, SkyLastNAme

 

[ajetrumpet]

But why the result comes to 0 records.


SELECT [2].SkyUsername
FROM 2
WHERE ((([2].SkyUsername) Not In (select adusername from 1)));

You're missing some syntax I think. Microsoft's DOT notation:

SELECT [2].SkyUsername
FROM 2
WHERE ((([2].SkyUsername) Not In (select [B][U][COLOR="Red"]1.[/COLOR][/U][/B]adusername from 1)));

edit

Also, are your tables really named "1", and "2", or are they really named "Table1" and "Table2"? If so, the table names are incorrect...