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