>>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
>
>You can do this two ways (unless I am missing something here).
>
>1) Do a union of the two selects above. Example
>
>select * from table1 where x=k;
>union;
>select * from table2 where y=h
>into cursor bigreport
>
>2) Union the two cursors together after the select are done (less efficent)
>
>select * from report1;
>union;
>select * from report2
>
>Note: programmers not in a collective agreement with be unable to use this command. :-)
>
>Hope this helps.

Thanks Evan! Union All works perfectly!

Jeff