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!!!