multiple internal tables in a where clause
I want to write a select query such that it selects data from a standard table based on the field values given in two different internal tables.
For eg.. stdtbl is name of standard table
itab1 has values for 3 of the columns and
itab2 has values for 2 of the columns
so is there any was such that i select records from stdtbl based on the entries in itab1 AND itab2.
One way I could think of is merging these internal tables in a third internal table.
pls suggest. !!