SELECT distinct code_p, sum(qte_l), sum(pu_l) FROM ventes GROUP BY code_p
select distinct code_p, sum(qte_l) as "qte_t", sum(pu_l) as"pu_t" from detail_bl group by code_p
DatabaseError with message 'ADOQuery2: field 'qte_l' not found'.....code sur clique bouton:
ADOQuery2.SQL.Clear; ADOQuery2.SQL.Add('select distinct code_p, sum(qte_l), sum(pu_l) from detail_bl group by code_p'); ADOQuery2.Open;
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question