Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Sql command to exclude records
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement