SELECT fanny_itineraire.num_quai_depart ,fanny_itineraire.num_quai_arrive ,IF(section.id_section=tonnages_depart_troncons.id_section_1,tonnages_depart_troncons.troncon_1,tonnages_depart_troncons.troncon_2) as troncon FROM fanny_itineraire JOIN fanny_quai q1 ON fanny_itineraire.num_quai_depart=q1.num_quai JOIN `section` on section.id_section=fanny_itineraire.num_section JOIN tonnages_depart_troncons ON fanny_itineraire.num_quai_arrive=tonnages_depart_troncons.num_quai_arrive AND fanny_itineraire.num_quai_depart=tonnages_depart_troncons.num_quai_depart WHERE fanny_itineraire.type_section='depart'