> In my real world app the IN statement has a couple of hundred values

and the

> query to filter for the values hits the system quite hard, so I was
> concerned that using that query in the IN clause would cause more system
> stress than supplying a string value generated from one execution of

that

> same query.

A couple of hundred is OK, although it hits the index for EACH member.
You will have problems if you try with 1500 though.

>
> I use the IN clause as part of a DELETE statement and I can't figure

out how

> to use joins to do that, or even if it will be possible at all. An

example

> would be appreciated.

It does not make sense to delete from a join. You can do

delete from sometable where ID in (select ID from sometable join ....)

Adam