Unnamed

SELECT bief_depart.b1, bief_depart.b2, fanny_tonnage.code_chapitre, sum( fanny_tonnage.cumul_tonne ) AS tonnageFROM bief_departJOIN fanny_tonnage ON ( bief_depart.num_quai_depart = fanny_tonnage.num_quai_departAND bief_depart.num_quai_arrive = fanny_tonnage.num_quai_arrive )WHERE bief_depart.pk_b1 = bief_depart.pk_b2GROUP BY fanny_tonnage.code_chapitre, bief_depart.b1, bief_depart.b2ORDER BY bief_depart.b1