>>>>I'm looking for advice on how I can either combine the following two select statements into one or how I can combine the result sets into one so I can use the data for a report.
>>>>
>>>>SELECT;
>>>>udds1, udds2, name;
>>>>FROM drivauth_view WHERE (ISNULL(udds1) = .f.);
>>>>AND (EMPTY(udds1) = .f.);
>>>>INTO CURSOR report1
>>>>
>>>>SELECT;
>>>>udds1, udds2, name;
>>>>FROM drivauth_view WHERE (ISNULL(udds2) = .f.);
>>>>AND (EMPTY(udds2) = .f.)
>>>>INTO CURSOR report2
>>>
>>>Probably this:
>>>SELECT;
>>>udds1, udds2, name;
>>>FROM drivauth_view
>>>WHERE (NOT ISNULL(udds1) AND NOT EMPTY(udds1)) ;
>>>Or (NOT ISNULL(udds2) AND NOT EMPTY(udds2))
>>>INTO CURSOR rpt
>>
>>When I run my first SQL statement, I get 10,182 records. When I run the second one I get 478 records. I tried your suggestion and got 10,182 records. Shouldn't I get 10,660?
>>
>>Jeff
>
>I have to admit, that you should, but... may be someone else will find error in code... I remember there some bugs for long NOT/AND/OR constructions.
>BTW, you could proceed with union, hopefully there you will get satisfactory result.

Thanks again Edward, union all works for what I need to do.

Jeff