Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
do inner join
Load *
resident tableA
inner join(tableA)
load*
resident tableB;
HTH
Sushil