SELECT * FROM TABLE1 WHERE !SEEK(PrimaryKey,"TABLE2","table2_PK")or when the table2 does not contain deleted records or the primary key is filtered with FOR !DELETED() you could tune performance by using:
SELECT Table2 nIndexNumber=TAGNO("Table2_pk") SELECT * FROM TABLE1 WHERE !KEYMATCH(PrimaryKEy,nIndexnumber,"TABLE2")I hope this helps.