How to obtain keys not in join

[#1]

Hi all,

I have two tables A and B.

A and B have the column "ID".

I need to obtain the intersection that is shown in the figure:

How can i write the join and obtain the keys that are in B and not in A?
Thank you.

[sunny_talwar · Accepted solution]

May be like this

A:

LOAD KeyField

FROM A;

B:

LOAD KeyField,

           OtherFields

FROM B

Where Not Exists(KeyField);

DROP Table A:

[#3]

Thank you!!