Hi Sergy,

I Wayyy over simplified that... So I should not have done
that... Sorry...

The 1st Table pulls out the Account Number information based
on the checking of 2 Tables, of about 241 million records...
The 2nd Query, I want to pull out the Account #'s that are not
in the First Query..

So I should have asked, how do I Select Records that are not
in a Select Statement that has just been run and returned
a result set somewhere...

Sorry about that...
Thanx!
Bob



>Hi Bob,
>
>Maybe I'm missing something but you can get the same result with one select

Select DISTINCT Acctnum from Checks

>
>>Hi All,
>>
>>I was wondering if it was possible to do this... In VFP I would do:
>>
>>

>>Select Acctnum ;
>> from Checks ;
>> Where checks.type = '1' ;
>> into cursor tmp1
>>
>>Select Acctnum ;
>> from Checks ;
>> Where Acctnum not in (Select Acctnum from tmp1) ;
>> Into Cursor tmp2
>>
>>Select * ;
>> from tmp1 ;
>> union ;
>> Select * ;
>> from tmp2 ;
>> Into cursor tmpFinal
>>

>>
>>Thanks in Advance!!
>>Bob