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

[sushil353]

do inner join

Load *

resident tableA

inner join(tableA)

load*

resident tableB;

HTH

Sushil