Bonsoir, j'essaye depuis ce matin de faire cette requête SQL via Flamerobin mais j'obtiens toujours le message 'Invalid expression in tghe select list (not contained in either an aggregate function or in the GROUP BY clause)

J'ai tout essayé (requêtes imbriquées, champ un par un, bouger les statements, toujours une erreur).

Merci de m'aider.

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
SELECT '70' AS Journal, TRESOR.TRESOR_TYPE, (iif(extract(day from TRESOR.TRESOR_DATE)<10,'0'||(extract(day from TRESOR.TRESOR_DATE)),(extract(day from TRESOR.TRESOR_DATE)))||
iif(extract(month from TRESOR.TRESOR_DATE)<10,'0'||(extract(month from TRESOR.TRESOR_DATE)),(extract(month from TRESOR.TRESOR_DATE)))
||right((extract(year from TRESOR.TRESOR_DATE)),2)) AS date_, TRESOR.TRESOR_PIECE AS IdFacture, (select CLIENT.CL_NOM AS Client FROM Client RIGHT OUTER JOIN TRESOR ON Client.CL_REF = TRESOR.CL_REF), 
 Sum(TRESOR.TRESOR_CREDIT) AS Debit, (select Sum(FACTURE.FA_HT) FROM FACTURE RIGHT OUTER JOIN TRESOR ON TRESOR.TRESOR_PIECE = FACTURE.FA_REF) 
 FROM TRESOR WHERE TRESOR.TRESOR_PIECE is not null GROUP BY TRESOR.TRESOR_DATE, TRESOR.TRESOR_TYPE