Hi,
Both yours and Sergeys answers still give "Too Complex" errors.

>>Hi,
>> Anyone have any idea why the following code would be throwing a "Too Complex" error.
>>
>>

>>Delete From pattern ;
>>Where pattern.patid In (Select CurRemove.patid From CurRemove) ;
>>.and. xpat.patid Not In (Select CurExcept.patid From CurExcept)
>>

>
>Use DELETE FROM syntax instead, e.g.
>

>delete Pattern from Pattern inner JOIN curRemove on Pattern.PaidID = curRemove.PatID LEFT JOIN curExcept on ;
>Pattern.PatID = curExcept.PatID where curExcept.PatID IS NULL

>
>I don't think you can use two sub-queries in DELETE syntax and also what is XPat in your query?