Hi,
I have also been here too long also, I was working on the wrong table.
>>Hi,
>>Both yours and Sergeys answers still give "Too Complex" errors.
>
>Are you sure that curRemove is the real cursor (created with NOFILTER clause)?
>
>How big are both cursors?
>
>You can also try
>
>select PatID from curRemove ;
>LEFT JOIN curExcept on curRemove.PatID = curExcept.PatID ;
>where curExcept.PatID IS NULL into cursor curReallyRemove nofilter
>
>delete Pattern from Pattern inner JOIN curReallyRemove on Pattern.PaidID = curReallyRemove.PatID
>
>I think both mine and Sergey's queries were wrong originally. But it's funny we both made the same mistake. It just shows that we have been here too long :)
Regards N Mc Donald