-- View: vu_fds_test

-- DROP VIEW vu_fds_test;

CREATE OR REPLACE VIEW vu_fds_test AS 
 SELECT fds_evenement.num_evenement, fds_evenement.date, fds_t_nature_animation.ref_nature_anim, fds_t_nature_animation.nature_animation
   FROM fds_evenement, fds_t_nature_animation
  WHERE fds_evenement.ref_nature_anim = fds_t_nature_animation.ref_nature_anim;

ALTER TABLE vu_fds_test OWNER TO postgres;

