Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I apologize. Do not have a copy of VFP on this machine, working with Access 2007 for the moment. I assumed that they would be similar enough for this example. If not, then I will wait.
Made the change to the EXISTS () part as follows and nothing was returned.
SELECT 1 FROM Table1, Table2 WHERE Table1.Fld2 IS NULL and Table1.FldID = Table2.FldID
Stripped it down even further to the following and a single row was returned and FieldWithOne = 1
SELECT 1 as FieldWithOne FROM Table1 WHERE Table1.Fld2 IS NULL
What is the purpose of the SELECT 1? Does it have a special meaning in VFP?
Précédent
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