What is wrong with query Mysql?

Question

There is an trivial SQL query:

SELECT enterprise_invoces.AC_name, 
enterprise_invoces.AC_id, 
enterprise_invoces.AC_code, 
ABS(SUM(IF(AT_amount>0, AT_amount, 0)) AS debit,
ABS(SUM(IF(AT_amount <0, AT_amount, 0)) AS credit 
    FROM account_transactions 
    INNER JOIN enterprise_invoces ON enterprise_invoces.AC_id = account_transactions.AT_code

I get this error message:

> # 1064 - You have an error in the request. Check the MySQL version documentation for correct syntax near 'FROM account_transactions INNER
> JOIN enterprise_invoces ON enterprise_invoces.AC' on line 1

Lukasz Szozda · Accepted Answer · 2019-07-01 21:22:39Z

4

You need to close brackets:

SELECT enterprise_invoces.AC_name, 
  enterprise_invoces.AC_id, 
  enterprise_invoces.AC_code, 
  ABS(SUM(IF(AT_amount>0, AT_amount, 0))) AS debit,  --here
  ABS(SUM(IF(AT_amount <0, AT_amount, 0))) AS credit  -- here
FROM account_transactions 
JOIN enterprise_invoces 
  ON enterprise_invoces.AC_id = account_transactions.AT_code
 GROUP BY enterprise_invoces.AC_name,
          enterprise_invoces.AC_id,
          enterprise_invoces.AC_code   -- there should be corresponding `GROUP BY`

answered Jul 1, 2019 at 21:22

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

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

Collectives™ on Stack Overflow

What is wrong with query Mysql?

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