I have a set of entries in internal table A.
Due to performance issues, I now want to make a single DB Lookup of table B with one column in table A as a filter. In SQL:
How do I make the "WHERE IN" condition or a workaround enabling a single lookup?
unfortunately, it is not possible to model the IN condition in the DB look up expression. I do not know what table A and B look like and how the data in table A is retrieved, but I see two options:
Hope that helps