Hi folks!
I Have two tables, and i need access data from both. below it's my tables;
CREATE TABLE Product (
CD_PROD INTEGER
CONSTRAINT PK_PROD NOT NULL PRIMARY KEY AUTOINCREMENT,
CD_REMT_COMM INTEGER
CONSTRAINT FK_PROD_REMT_COMM REFERENCES
Remote_command(CD_REMT_COMM),
CD_IDEN_PROD TEXT NOT NULL,
NM_PROD TEXT NOT NULL,
CD_ALIQ INTEGER NOT NULL
CONSTRAINT FK_PROD_ALIQ REFERENCES Aliquot(CD_ALIQ),
CD_DEPA INTEGER NOT NULL
CONSTRAINT FK_PROD_DEPA REFERENCES Department(CD_DEPA),
CD_MEASURE_UNIT INTEGER NOT NULL
CONSTRAINT FK_PROD_MEASURE_UNIT REFERENCES
Measure_unit(CD_MEASURE_UNIT),
FL_UNITARY_TICKET INTEGER NOT NULL,
CONSTRAINT FL_PROD_COMIS CHECK(FL_PROD_COMIS in (0,1)),
CONSTRAINT FL_STOCK_PROD_CTRL CHECK(FL_STOCK_PROD_CTRL in (0,1))
);
and
CREATE TABLE Current_sale_item (
CD_CURR_SALE_ITEM INTEGER
CONSTRAINT PK_CURR_SALE_ITEM NOT NULL PRIMARY KEY AUTOINCREMENT,
CD_CURR_SALE INTEGER NOT NULL
CONSTRAINT FK_CURR_SALE_ITEM_CURR_SALE REFERENCES
Current_sale(CD_CURR_SALE),
CD_PROD INTEGER NOT NULL
CONSTRAINT FK_CURR_SALE_PROD REFERENCES Product(CD_PROD),
QT_SALE_ITEM REAL NOT NULL,
VL_INCR_ITEM REAL NULL,
VL_DISCT_ITEM REAL NULL,
CD_REMT_COMD INTEGER NOT NULL,
FL_CANC INTEGER NOT NULL
);
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> *
But, my example of query return this! :(
* 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;
si.CD_CURR_SALE_ITEM|SUM(si.QT_SALE_ITEM)|p.CD_IDEN_PROD|p.NM_PROD
15|72.0|000000000000-1|Motorola V66V
*sqlite> *
I need sum only col *si.CD_CURR_SALE* equals by p.CD_PROD
Somebody can help-me?!
