Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECT's Queries, which includes EXIST filter
Message
De
10/11/1997 18:35:52
 
 
À
10/11/1997 12:33:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00059303
Message ID:
00059411
Vues:
33
>>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)

There is no "EXIST IN" condition for SELECT-SQL. There is "EXISTS" and "IN", but you cannot combine them.

Vlad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform