I'm sure that you can do it in one command, but in practice it's two separate operations for your computer. I believe your solution will be faster.

>Something like that?
>

>SELECT;
>" " as MatProblem,;
>CAST("" AS M) AS Missing,;
>Curx.Line,Curx.priority,Curx.Customer,;
>Curx.CUT,Curx.Desc_Cut,Curx.STYLE,Curx.Desc_Style,Curx.DUEDATE,;
>Curx.total,Curx.totstd,Curx.cutdate,;
>00000.00 as timetictot,;
>00000.00 as timetic,;
>00000.00 as balance,;
>00000.00 as diasf,;
>0000000.00 as horasf,;
>DATE() as fec,;
>00 as horad;
>FROM (;
>  SELECT Cut.Line, priority, bname as Customer, cut.CUT, cut.description as Desc_Cut, style.STYLE,;
>		style.description as Desc_Style, DUEDATE, cut.total, totstd,cutdate;
>	FROM cut, cutdtl, style, customer;
>	WHERE cut.custcode = customer.code;
>	AND cut.cut = cutdtl.cut;
>	AND cutdtl.style = style.style;
>	AND duedate >= thisform.text1.Value AND duedate <= thisform.text2.Value;
>	AND EMPTY(dtcompl);
>	AND cut.total > thisform.text10.Value;
>	&lcExtra1 &lcExtra2;
>	DISTINCT) as curx;
>	INTO CURSOR cur1 READWRITE;
>	ORDER BY Priority, DueDate
>

>
>>When you use Distinct, you have to add the memo field afterwards by using Alter Table.