MyTable myTable1, myTable2; ; select count(RecId) from myTable1 notexists join myTable2 where myTable2.fldName == myTable1.fldName && myTable2.RecId < myTable1.RecId;