Maneesh A N

Maneesh A N

  • NA
  • 179
  • 81.9k

SUM

Sep 2 2013 6:06 AM
SELECT  SUM(SI.vItemName),SUM(SI.iNos),SUM(SI.deAmount),SUM(TS.dInvoiceDate),
 FROM tblSales TS INNER JOIN tblSalesItem SI ON TS.iSalesID=SI.iSalesID
GROUP BY   SI.vItemName, SI.iNos, SI.deAmount,TS.dInvoiceDate



Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'FROM'.


GET ME ANSWER SOON?PLS

Answers (2)