Summing Columns

Question

SELECT SI.vItemName SI.iNos SI.deAmountTS.dInvoiceDate SUM(SI.tblSalesItem.orders) FROM tblSales TS INNER JOIN tblSalesItem SI ON TS.iSalesID=SI.iSalesID GROUP BY SI.vItemName SI.iNos SI.deAmountTS.dInvoiceDate ERROR IN SQL 2005 Msg 102 Level 15 State 1 Line 7 Incorrect syntax near 'SI'. PLEASE CORRECT?

Kunal Vaishya · Answer

Please try this may be problem resolved SELECT SI.vItemName SI.iNos SI.deAmount TS.dInvoiceDate SUM(SI.orders) FROM tblSales TS INNER JOIN tblSalesItem SI ON TS.iSalesID=SI.iSalesID GROUP BY SI.orders SI.vItemName SI.iNos SI.deAmountTS.dInvoiceDate

Muralidharan Deenathayalan · Answer

Try this. SELECT SI.vItemName SI.iNos SI.deAmount TS.dInvoiceDate  SUM(SI.tblSalesItem.orders) FROM tblSales TS INNER JOIN tblSalesItem SI ON TS.iSalesID=SI.iSalesID GROUP BY SI.vItemName SI.iNos SI.deAmountTS.dInvoiceDate

Prasenjit Dey · Answer

Copy and paste code again SELECT SI.vItemName SI.iNos SI.deAmountTS.dInvoiceDate SUM(SI.tblSalesItem.orders) FROM tblSales TS INNER JOIN tblSalesItem SI ON TS.iSalesID=SI.iSalesID GROUP BY SI.vItemName SI.iNos SI.deAmountTS.dInvoiceDate if error still occoured then please provide a snapshot