跳至内容
菜单
此问题已终结
1 回复
2901 查看

SELECT a.analytic_account_id AS x_analytic_account_id, SUM(a.credit - a.debit) AS x_sale FROM account_move_line AS a JOIN account_account AS b ON a.account_id=b.id JOIN account_account_type AS c ON b.user_type_id=c.id WHERE c.name = 'Income' AND a.parent_state ='posted'

Error:

column "a.analytic_account_id" must appear in the GROUP BY clause or be used in an aggregate function LINE 2: a.analytic_account_id AS x_analytic_account_id,

 

形象
丢弃
最佳答案

Hi,

Add  "GROUP BY a.analytic_account_id" at the end after your "WHERE " condition

SELECT a.analytic_account_id AS x_analytic_account_id, SUM(a.credit - a.debit) AS x_sale
FROM account_move_line AS a
JOIN account_account AS b ON a.account_id = b.id\\\
JOIN account_account_type AS c ON b.user_type_id = c.id
WHERE c.name = 'Income' AND a.parent_state ='posted'
GROUP BY a.analytic_account_id

In  newer  versions  of  pgadmin  using postgresql , every column which you are viewing need to be in group by clause

Thanks

形象
丢弃
相关帖文 回复 查看 活动
0
10月 21
1691
1
4月 24
1719
1
4月 24
2067
0
9月 23
6216
1
11月 22
5553