select myTable1 notexists join myTable2 where myTable1.ID == myTable2.ID && myTable1.RecId > myTable2.RecId;