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

the DELETE SQL WHERE support one subqruery only.

Delete From pattern ;
Where patid In (Select patid From CurRemove WHERE patid NOT In (Select patid From CurExcept))