João,

In GROUP BY and SORT BY clauses of a query you specify columns either by name

GROUP BY customer, material

or by order in the select list

SELECT customer, material, ...
...
GROUP BY 1,2

>Hi Sergey,
>
>I solved the problem like this, your tips help me
>
>

>SELECT *, ;
>    SUM(IIF( ficmvmp.movimento <= 49, Quantidade, 0)) AS Qin, ;
>    SUM(IIF( ficmvmp.movimento >  51, Quantidade, 0)) AS Qout ;
>    FROM ficmvmp ;
>    left outer join ficmater ;
>    on material = artigo ;
>    left outer join ficmolde ;
>    on terceiro = val(ficmolde.molde) ;
>    group by 1,2,material;
>    INTO CURSOR STK_TMP
>

>
>What i don't understand is group by 1,2 ????.
>
>Thank's for all your time, i'm relly newbie with SQL Select more complex.
>
>João