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