SELECT	event_natanim.date,
	event_natanim.duree,
	event_natanim.id_depart,
	event_natanim.newcodesite,
	event_natanim.insee,
	event_natanim.operation,
	event_natanim.destination,
	event_natanim.nature_animation,
	fds_t_type_scolaire.type_scolaire,
	event_natanim.presse_avs,
	event_natanim.radio_avs,
	event_natanim.tele_avs,
	event_natanim.affiche_avs,
	event_natanim.calendrier_avs,
	event_natanim.presse_aps,
	event_natanim.radio_aps,
	event_natanim.tele_aps,
	event_natanim.presence_journalistes,
	event_natanim.presence_tv,
	event_natanim.presence_radio,
	event_natanim.commentaire1
FROM
(SELECT	event_dest.date,
	event_dest.duree,
	event_dest.ref_type_scolaire,
	event_dest.presse_avs,
	event_dest.radio_avs,
	event_dest.tele_avs,
	event_dest.affiche_avs,
	event_dest.calendrier_avs,
	event_dest.presse_aps,
	event_dest.radio_aps,
	event_dest.tele_aps,
	event_dest.presence_journalistes,
	event_dest.presence_tv,
	event_dest.presence_radio,
	event_dest.id_depart,
	event_dest.commentaire1,
	event_dest.newcodesite,
	event_dest.insee,
	event_dest.operation,
	event_dest.destination,
	fds_t_nature_animation.nature_animation
FROM
(SELECT event_op.date,
	event_op.duree,
	event_op.ref_nature_anim,
	event_op.ref_type_scolaire,
	event_op.presse_avs,
	event_op.radio_avs,
	event_op.tele_avs,
	event_op.affiche_avs,
	event_op.calendrier_avs,
	event_op.presse_aps,
	event_op.radio_aps,
	event_op.tele_aps,
	event_op.presence_journalistes,
	event_op.presence_tv,
	event_op.presence_radio,
	event_op.id_depart,
	event_op.commentaire1,
	event_op.newcodesite,
	event_op.insee,
	event_op.operation,
	fds_t_destination.destination
FROM 
	(SELECT fds_evenement.num_evenement,
	fds_evenement.date,
	fds_evenement.duree,
	fds_evenement.ref_destination,
	fds_evenement.ref_operation,
	fds_evenement.ref_nature_anim,
	fds_evenement.ref_type_scolaire,
	fds_evenement.presse_avs,
	fds_evenement.radio_avs,
	fds_evenement.tele_avs,
	fds_evenement.affiche_avs,
	fds_evenement.calendrier_avs,
	fds_evenement.presse_aps,
	fds_evenement.radio_aps,
	fds_evenement.tele_aps,
	fds_evenement.presence_journalistes,
	fds_evenement.presence_tv,
	fds_evenement.presence_radio,
	fds_evenement.id_depart,
	fds_evenement.commentaire1,
	fds_evenement.newcodesite,
	fds_evenement.insee,
	fds_operation.operation
	FROM fds_evenement
      	LEFT JOIN fds_operation ON fds_evenement.ref_operation = fds_operation.ref_operation) event_op
	LEFT JOIN fds_t_destination ON event_op.ref_destination = fds_t_destination.ref_destination) event_dest
	LEFT JOIN fds_t_nature_animation ON event_dest.ref_nature_anim = fds_t_nature_animation.ref_nature_anim) event_natanim
	LEFT JOIN fds_t_type_scolaire ON event_natanim.ref_type_scolaire = fds_t_type_scolaire.ref_type_scolaire;