Jim --

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 ;
> WHERE First condition is true ;
>   AND MyTable.Primarykey NOT IN (SELECT PrimaryKey ;
>                                    FROM MyTable BB ;
>                                   WHERE Second condition is not .T.) ...
>