Miscellany

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 tronconFROM fanny_itineraireJOIN 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'