Summing Columns

Kunal Vaishya13y ago

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.deAmount,TS.dInvoiceDate

0

13y ago

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.deAmount,TS.dInvoiceDate

0

Prasenjit Dey13y ago

Copy and paste code again,

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.deAmount,TS.dInvoiceDate

if error still occoured, then please provide a snapshot

0