Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT's Queries, which includes EXIST filter
Message
From
10/11/1997 18:35:52
 
 
To
10/11/1997 12:33:38
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00059303
Message ID:
00059411
Views:
28
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform