-- View: vu_fds_theme_par_event

-- DROP VIEW vu_fds_theme_par_event;

CREATE OR REPLACE VIEW vu_fds_theme_par_event AS 
 SELECT fds_evenement.num_evenement, fds_evenement.date, fds_lesthemes.ref_theme, fds_lesthemes.theme
   FROM ( SELECT fds_evt_theme.num_evenement, fds_theme.ref_theme, fds_theme.theme
           FROM fds_evt_theme, fds_theme
          WHERE fds_evt_theme.ref_theme = fds_theme.ref_theme) fds_lesthemes
   JOIN fds_evenement ON fds_evenement.num_evenement = fds_lesthemes.num_evenement
  ORDER BY fds_evenement.num_evenement;

ALTER TABLE vu_fds_theme_par_event OWNER TO postgres;

