Join Tables with sum in sql query

Question

It is showing Sum(with table name) is not valid. Kindly help:

Modws.DisplayDataGrid(dgvClosingBalance, 
                      "Select 
                           Invoice.Customer, Invoice.Sum(Total), 
                           RptTempTable.Sum(INVOICETOTAL), RptTempTable.Sum(CNTOTAL), 
                           RptTempTable.Sum(DEBITTOTAL), RptTempTable.Sum(RECEIPTTOTAL) 
                       From Invoice 
                       inner join RptTempTable on Invoice.Customer = RptTempTable.Customer")

Whats the exact error? what is the data type of the field your trying to SUM — Matt
– Matt, Commented Nov 18, 2014 at 9:36
all is decimal data type..i want to show the sum of all from 2 different tables in a grid view — durga muthiah
– durga muthiah, Commented Nov 18, 2014 at 9:37
There is no group by in your statement. Also: which DBMS are you using? Postgres? Oracle? — user330315
– user330315, Commented Nov 18, 2014 at 9:37

user330315 · Accepted Answer · 2014-11-18 09:41:36Z

1

RptTempTable.Sum(INVOICETOTAL) should be Sum(RptTempTable.INVOICETOTAL)

The same goes for the other calls to sum()

The table prefix belongs to the column name not the function call.

MySQL will accept this invalid SQL and will return "inderminate" (aka "random") values instead.

To understand the implications of MySQL's "loose" (aka "sloppy") group by implementation you might want to read these articles:

answered Nov 18, 2014 at 9:41

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Join Tables with sum in sql query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related