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