I already had the IN clause in my select. I was hoping to improve performance
by using a JOIN.
>>Yes, this Select should be splitted on two, the first one will do Select Distinct ... Into Cursor..., and next one will join the cursor.
>
>Not necessaraly. You can do the same if you move JOIN into where condition like
>
>where ResNum in (select distinct ResNum from ...)
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people