>>

... 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.


Roi,

It really doesn't matter as the cursor tasks is local and your subselect has no filter on it, VFP is always going to use the cursor itself rether than pull records from it to another cusros.