topic Re: table a intercept table b in Application Development and Automation Discussions

table a intercept table b

Former Member — Wed, 02 Jan 2008 04:45:01 GMT

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 — Wed, 02 Jan 2008 05:09:24 GMT

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).