Table Subtraction - where items not exist

[engishfaque]

Dear All,

I have two tables called Table A and Table B or vice versa. And I have to subtract items and find unique items from Table B from both tables such as given below tables.

Table A

Itmes

ADF-JPS-001

ADF-JPS-001-ZZ0

ADF-JPS-001-ZZ1

Table B

Itmes

ADF-JPS-001

ADF-JPS-001-ZZ0

ADF-JPS-001-ZZ1

NR-87913

NI-R6501-ZZ8

Required output:

Itmes

NR-87913

NI-R6501-ZZ8

Kind regards,

Ishfaque Ahmed

[MK_QSL · Accepted solution]

T1:

Load * From Table1;

NoConcatenate:

T2:

Load * From Table2 where not exists(Items);

Drop Table T1;