Hi kevin,

Another approach would be

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.

Walter,

>Hi
>
>Table1 is related to Table2.
>
>I want to run a SELECT on Table1 and only obtain records that DO NOT have a related record in Table2.
>
>Can anyone help me on this.
>Thanks
>Kev