>>
... where fk_task_id in (select TaskID from tasks)
>
>I Knew that. I was wondering if I could replace the (select TaskID from tasks) with only the cursor name. So the select doesn't have to execute.
Nope. The only alternate is to put all the possible values there:
in ('val1', 'val2', ...)
Mark McCasland
Midlothian, TX USA