Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with Sql Select
Message
 
 
To
28/04/2003 11:58:08
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00782286
Message ID:
00782288
Views:
14
This message has been marked as the solution to the initial question of the thread.
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform