General information
Category:
Coding, syntax & commands
About EXISTS:
Almost all EXISTSs can be replaced with IN conditions. From my experience, doing this replace gives simplier and faster queries.
Vlad
>>>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!!!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only