Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use select... where EXISTS ... ?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00793069
Message ID:
00793074
Views:
42
>I don't see anything wrong with this query. What error do you get?
>
>>What is wrong with this :
>
>SELECT taitem.ident;
>>       FROM taitem;
>>       WHERE EXISTS (SELECT arcode.code FROM arcode ;
>>	                  WHERE taitem.code = arcode.code AND;
>>       	                        arcode.activity = "EA")
>
>
>>VFP7 ask me about EXISTS ?
>>
>>Help!
>>
>>Thanks
>>Eric
ARGH! There is nothing wrong with this. Like 99% of the time, the problem was me! Time to switch career and go sell hotdogs! Sorry for disturbing!
Eric Crespin
Consultant
PC PLUS Software Inc.
www.pcplus.ca
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform