-- View: vu_fds_partenaire_par_event

-- DROP VIEW vu_fds_partenaire_par_event;

CREATE OR REPLACE VIEW vu_fds_partenaire_par_event AS 
 SELECT fds_evenement.num_evenement, fds_evenement.date, fds_organisme.ref_intervenant, fds_organisme.organisme
   FROM ( SELECT fds_evt_intervenant.num_evenement, fds_intervenants.ref_intervenant, fds_intervenants.organisme
           FROM fds_evt_intervenant, fds_intervenants
          WHERE fds_evt_intervenant.ref_intervenant = fds_intervenants.ref_intervenant) fds_organisme
   JOIN fds_evenement ON fds_evenement.num_evenement = fds_organisme.num_evenement
  ORDER BY fds_evenement.num_evenement;

ALTER TABLE vu_fds_partenaire_par_event OWNER TO postgres;

