Won't 2 conditions in the WHERE clause suffice, rather than using a subquery in this situation?
Jay
>Steve, > >Try something like this; > >
>
>SELECT * ;
> FROM MyTable ;
> WHEREFirst condition is true ;
> AND MyTable.Primarykey NOT IN (SELECT PrimaryKey ;
> FROM MyTable BB ;
> WHERESecond condition is not .T.) ...
>