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