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

Click here to load this message in the networking platform