Hi,

I have two tables with these set of data:

Table1

Filed1 Field2
1000 A
1001 B
1002 C
1003 D
1004 E

Table2

Filed1 Field2
1000 A
1002 C
1003 D
1005 F
1006 G

I need to create 3 Tables with following out put.

1. Data that are common to both Table1 & Table2

2. Data that are in Table1 but do no exist in Table2

3. Data that are in Table2 but do not exist in Table1

Can anyone help me to find the answer please.

Cheers

Bud

1 Use a simple join
2 & 3 use the unmatched query wizard

Brian