SELECT * ; FROM MyTable ; WHERE First condition is true ; AND MyTable.Primarykey NOT IN (SELECT PrimaryKey ; FROM MyTable BB ; WHERE Second condition is not .T.) ...