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