I have two fileds Number in Filed 1 not in field 2

[miziri]

Hi,
I have in table two filed A,b with number see below example
A B


1 41
43 21
21 11
5 4
22 11
------------
Need quiry compare A with B show number I have in A not avaible in B result must be
A
1
43
5
those number avaible in A,not avaible in B
Thanks

[kimmer]

1. Make a new query.
2. Add the table to the query two times.
3. Create a join between FieldA of the original table and FieldB of the copy table.
4. Change the join type to a left join to include all of the records in the original table.
5. Add FieldA from the original table to the grid.
6. Add FieldB from the copy table to the grid.
7. Set criteria of FieldB to Is Null.
8. Turn on Group By.

Here is the SQL:

SELECT tblMyTable.FieldA, tblMyTable_1.FieldB
FROM tblMyTable LEFT JOIN tblMyTable AS tblMyTable_1 ON tblMyTable.FieldA = tblMyTable_1.FieldB
GROUP BY tblMyTable.FieldA, tblMyTable_1.FieldB
HAVING (((tblMyTable_1.FieldB) Is Null));