We have table like this table1
Customer ItemNumber Item_Name Qty FOCQty
C1 I1 ABC 10 2
C2 I2 BCA 12 2
C3 I1 ABC 3 3
C4 I2 BCA 05 1
We need like this
ItemNumber Item_Name Qty FOCQty
I1 ABC 13 5
I2 BCA 17 3
We tried Like this
tx.executeSql('SELECT ItemNumber,Item_Name,sum(Qunatity) as Qunatity1 ,sum(FOCQty) as FOCQty1 from toCSV5 Where ItemNumber=?',[this.UpdateItemNumber],SumSuccess,errorCB);
but it not work for US Please tell me what wrong in my-code
Aucun commentaire:
Enregistrer un commentaire