SELECT Ref, SUM(Qtd) AS Qtd ;
FROM mytable ;
GROUP BY Ref
>Hi
>
>I have table EnLinha with fields Ref , Qtd
>
>Browse :
>
>Artigo1 , 10
>Artigo2 , 20
>Artigo1 , 05
>Artigo3 , 30
>Artigo2 , 01
>
>I want make one select sql , so i have one table , where browse is
>
>Artigo1 , 15
>Artigo2 , 21
>Artigo3 , 30
>
>Thanks
--sb--