Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Another Subquery Problem
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00053707
Message ID:
00053730
Views:
34
>>Oh good grief I see what your saying. I went back to my job specification and it seems data definitions for each of my three tables was given to me wrong. Guess it was just too long of a day yesterday to see it with my own eyes :) Here's what I revised and have running now:
>>
>>SELE azactive.acct AS account, azactive.name FROM azactive ;
>> WHERE NOT EXISTS( ;
>> SELE * FROM addunit WHERE addunit.account==azactive.acct) ;
>> INTO CURSOR temp1
>>
>>SELE azactive.acct AS account, azactive.name FROM azhandle, azactive ;
>> WHERE NOT EXISTS( ;
>> SELE * FROM azhandle WHERE azhandle.account==azactive.acct) ;
>> INTO CURSOR temp2
>>
>>Look Better?
>
>First Select looks Ok now, but second one still carries the same thing. You probably forgot to remove 'azhandle' from 'FROM ...'

Oh your right... hard to re-code and eat lunch at the same time ;) BTW first query now ran in about 2 minutes. Thank you Edward!!!
Roxanne M. Seibert
Independent Consultant, VFP MCP

Code Monkey Like Fritos
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform