...)) AS Qout, ;
>Hi Sergey,>SELECT ficmolde, ficmater, ; > SUM(IIF( movimento <= 49, Quantidade, 0)) AS Qin, ; > SUM(IIF( movimento > 51, Quantidade, 0)) AS Qout, ; > from ficmvmp ; > group by 1,2 >>and it gives an error to me
'command is missing required clause'
>