Hello Experts,
I am struggling with a problem.
In my development I have two db tables for eg. Table A and Table B.
Now table A has about 200,000 entries and table B has about 800,000 entries.
I want to delete all the extra entries (junk entries-not present in A but present in B) from table B on the basis of one field that is common between them
i.e. All the entries for whom 'A-field NE B-field'
Now i tried using internal tables but the loop execution is taking forever.
And I tried using a Select query for all entries:
SELECT *
FROM B
INTO TABLE itab_B
FOR ALL ENTRIES IN itab_A
WHERE field EQ itab_A-field.
This query gives me the records which are present in both tables.
But if I try to change the 'where' condition to 'NE' it does not work.
Is there any join statement to meet my requirement?
Thanks in Advance
Omkar