I haven't tried a subquery in a DELETE before, but it seems like the best idea. Any other method would likely run into the line length limit.
>I have a situation where I need to delete records
>based on any one of 100 foreign keys. A total of
>about 400,000 records need to be purged.
>
>What is the best way to achieve this goal. I could
>do a DELETE FOR INLIST(fk, 2,5,7,8,9,...xxx) but inlist
>is limited to 24 expressions.
>
>Perhaps a DELETE FROM tablex WHERE fk IN (sub query)
>is the best...