>I need to run a SQL statement which selects all records from File1 ,but excludes any records where there is a link to a second file based on one of the fields:
>
>In simple terms:
>
>e.g. File 1: F1_code,F1_Name
> File 2: F2_Code
>
>
>Select * from File1 where (F1_code does not already exist in File2)
>
>Is there a way of doing this in SQL. I tried using a where Seek(..) = .F. but know from past experience that its a bit dicey using functions inside a SQL statement
>
>Regards,
>
>Gerard

HI,

SELECT * FROM File1 WHERE F1_code NOT IN (SELECT DISTINCT F2_Code FROM File2)