Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select with Subquery confusion
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00053103
Message ID:
00053107
Views:
30
>>Why not to use:
>>SELECT * FROM ALPHA_X WHERE stype!="WL " OR progtype!="NP" ;
>> INTO CURSOR ALPHATMP
>
>I did do it that way just to get job out, but this week's learning curve was to conquer Subqueries... Was just trying to meet the daily workload AND learn something at the same time. :D)

I guess Foxpro doesn't like to have the same FROM table in both main query and subquery.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform