SELECT Fields from Table1 WHERE KeyField NOT IN (SELECT KeyField FROM Table2)


>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