Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>Does Fox SQL Syntax allow for following?:
>>
>>SELECT table1.orderid FROM table1 WHERE table1.orderid NOT IN table2.orderid
>>
>>Thanks,
>
>SELECT table1.orderid FROM table1 WHERE table1.orderid NOT IN (select table2.orderid from table2)
>
>or, in VFP 6.0 this is I think an OUTTER JOIN would do this too.
>
>BOb
I don't think an OUTER JOIN works here. The object is to get records from table 1 that are not in table2 based on orderid. An OUTER JOIN, be it LEFT, RIGHT, or FULL would probably get you those record but would, unfortunately, also include records WHERE table1.orderid IN (SELECT table2.orderid FROM table2).
Précédent
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