Jorge Pereira <[EMAIL PROTECTED]> wrote:
I execute this query below, following result.
sqlite> SELECT
si.CD_CURR_SALE_ITEM,si.QT_SALE_ITEM,p.CD_IDEN_PROD,p.NM_PRODFROM
Current_sale_item si, Product p WHERE
si.CD_PROD = p.CD_PROD;
CD_CURR_SALE_ITEM|QT_SALE_ITEM|CD_IDEN_PROD|NM_PROD
1|2.0|000000000000-1|Motorola V66V
2|3.0|000000000003-1|Celular Sony
3|55.0|000000000005-1|Tabajara N195
4|1.0|000000000000-1|Motorola V66V
5|1.0|000000000002-1|Gradiente Strike
6|1.0|000000000002-1|Gradiente Strike
7|1.0|000000000002-1|Gradiente Strike
8|1.0|000000000002-1|Gradiente Strike
9|1.0|000000000002-1|Gradiente Strike
10|1.0|000000000002-1|Gradiente Strike
11|1.0|000000000002-1|Gradiente Strike
12|1.0|000000000002-1|Gradiente Strike
13|1.0|000000000002-1|Gradiente Strike
14|1.0|000000000000-1|Motorola V66V
15|1.0|000000000000-1|Motorola V66V
sqlite>
i need something for sum the second col, ex:
*sqlite>* SELECT
si.CD_CURR_SALE_ITEM,*SUM(si.QT_SALE_ITEM)*,p.CD_IDEN_PROD, p.NM_PROD
FROM Current_sale_item si, Product p WHERE si.CD_PROD = p.CD_PROD;
CD_CURR_SALE_ITEM|QT_SALE_ITEM|CD_IDEN_PROD|NM_PROD
1|2.0|000000000000-1|Motorola V66V 2|3.0|000000000003-1|Celular Sony
3|55.0|000000000005-1|Tabajara N195
4|1.0|000000000000-1|Motorola V66V
* 5|9.0|000000000002-1|Gradiente Strike*
14|1.0|000000000000-1|Motorola V66V
15|1.0|000000000000-1|Motorola V66V
* sqlite> *
Why do you, in your example, sum up nine records where product is
'Gradiente Strike', but not the three records where product is 'Motorola
V66V'? What meaning does CD_CURR_SALE_ITEM column have when the row may
be a combination of multiple sale items?
While it's not clear what exactly you are trying to achieve, see if this
works for you:
SELECT si.CD_CURR_SALE_ITEM, SUM(si.QT_SALE_ITEM),
p.CD_IDEN_PROD, p.NM_PROD
FROM Current_sale_item si, Product p
WHERE si.CD_PROD = p.CD_PROD
GROUP BY p.CD_IDEN_PROD;
Read about GROUP BY clause in your favorite SQL textbook.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------