Yes it was that Thanks sab
Replace GROUP BY
CL.QUANTITE,CL.PRIX_UNITAIRE,CL.TAUX_REMISE,CL.TAUX_TVA,CL...COMMANDE_ID
By
GROUP BY CL.COMMANDE_ID
Provenance : Courrier pour Windows 10
De : m_brahi...@yahoo.fr [firebird-support]
Envoyé le :lundi 25 décembre 2017 21:09
À : firebird-support@yahoogroups.com
Objet :[firebird-sup
Sorry, it was an SQL and not FB problem
Thanks Karol
Hi,
if you need only one record then why do you use GROUP BY?
GROUP BY divide your resultset into defined groups.
Remove whole GROUP BY and acquire sum from whole records as 1 record result
regards,
Karol Bieniaszewski
From: m_brahi...@yahoo.fr [firebird-support]
Sent: Monday, December 25, 201
