Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECT's Queries, which includes EXIST filter
Message
 
À
10/11/1997 12:33:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00059303
Message ID:
00059309
Vues:
32
>>As I know there is SELECT's filter using EXIST, which format is:
>>SELECT <...> WHERE EXIST (subquery)
>>
>>How to use it? I have found very little information about it
>>in VFP Help. I have tried it with 2 tables with diferent fields,
>>but didn't work. :(
>
>SELECT SomeField FROM TableA WHERE ExtKey EXIST IN
>(SELECT Key FROM TableB)
Can you explain what do you mean by "ExtKey".

For Example, I have 2 tables:
Table1: T1.dbf
Fields: L1 C(5), L2 N(2,0), L3 L
and
Table1: T2.dbf
Fields: L1 C(5), L2 L

and want to know which record from table T1 don't exists in table T2?
Giedrius
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform