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 ON fanny_itineraire.num_quai_depart=fanny_quai.num_quai									JOIN `section` on `section`.id_section=fanny_itineraire.num_sectionJOIN 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'