Hi Bob,

If you've to reuse result of the first query, you can store it into temporary table or table variable. Otherwise, you can include the first query as subquery in the second one.

-- Temp table
SELECT Acctnum 
	INTO #temp01
	FROM Checks 
	WHERE Checks.TYPE = '1' 

SELECT Acctnum FROM #temp01
UNION 
SELECT Acctnum FROM Checks 
	WHERE Acctnum NOT IN (SELECT Acctnum FROM #temp01)
DROP TABLE #temp01
--

SELECT Acctnum FROM Checks 
	WHERE Acctnum NOT IN (
		SELECT Acctnum FROM Checks 
			WHERE Checks.TYPE = '1' )

>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