table a intercept table b

[Former Member]

hi, i need some help.

example:

from table A column A subtract table B column A

the result showing table a column A's records not in table B column A's records.

is there any method or any select to retrieve it..?

the whole idea must be in dynamic.

[Former Member]

Friend,

for example,

select * from but000 into table itab where partner not in ( select partner from but020 ).

select * from tableA into table itabA where columnA not in ( select columnA from tableB).