Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
1 Rispondi
2921 Visualizzazioni

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,

 

Avatar
Abbandona
Risposta migliore

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

Avatar
Abbandona
Post correlati Risposte Visualizzazioni Attività
0
ott 21
1691
1
apr 24
1748
1
apr 24
2077
0
set 23
6223
1
nov 22
5574