Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Another Subquery Problem
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00053707
Message ID:
00053730
Vues:
39
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform