>>>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.
Edward Pikman
Independent Consultant