DELETE rows internal table from interal table

[mark_fryu]

is there any way to delete all rows of an internal table from an internal table?

for example :

DELETE <table1> from <table2> where <table1-field> eq <table2-field>

even without where is fine, I need everything in table2 to delete everything in table1

[abo]

Something like this?

[mark_fryu]

from the link I did not understand how to do it, can you give me a practical example? thank you

[Abinathsiva]

Hi,

one way is looping table2 and delete table1 by comparing table2-field (will affect the performance based on table size.

load table2-field to single selection or equalant one and use

DELETE table1 where field in s_field.