samedi 9 mai 2015

need a correction for my request

this is my request

            sql = "SELECT t1.*, SUM(t2.id_qte) as totalamount FROM articletable t1 INNER JOIN associationdepotarticle t2 ON t1.fusiontable = t2.fusiontable GROUP BY t1.designation, t2.id_bonreception";

its work but i get 2 khoubz and 2 chawarma

i want just get

chawarma = 2

khoubz = 1

what i need to do ?

thanks first

i get this result :( http://ift.tt/1H9KbhQ

Aucun commentaire:

Enregistrer un commentaire