This message was deleted.

Hi Shantha, with only 100 values in an IN() clause it may be easier to just do this inline. However if performance is a concern then I suggest try it both ways, and check the Explain Plan to see how the queries differ (e.g. Filter vs Join)