>>I see grave problems in your queries. Let's look at first Select. I understand that you want to retrieve all addunit.account which are not in azactive table. So far, so good, but after VFP retrieved them, how it's going to link azactive.name to new records. The only answer from your code is to make cross join, i.e. ~46K addunit records multiply 193K azactive. It's not surprizing that you are out of space.
>
>
>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 ...'