Resident Table join to bring out Unique values

[#1]

Hello:

Can any one help me with teh following solution I am looking for:

I have two resident tables A & B, and both have one field "Part", how can I join these two resident tables and bring out just the unique values from the

"Part" field, that is just want to see only values that is in table A and not in table B and vice versa. 

Any help will be greatly appreciated.

thanks

Kumar

[#2]

Many thanks Mr.Neves for your time in explaining my query,

is there any possibility that part B & F can be isolated and

loaded into a resident table .

This is because part B is in Table A but not in Table B

and part F is in Table B but not in Table A

Thanks in advance for any help you can offer

Kumar Ramanujam

Senior Data Analyst

Victaulic Company of America

kramanujam@victaulic.com

Phone: + 610-559-3601

Cell: + 484-226-6510

[Gysbert_Wassenaar]

See attached example