CREATE OR REPLACE VIEW vu_fds_event_alljoin_nivoscol AS 

select	vu_fds_event_alljoin_details.*,
	vu_fds_event_etablis_sco.typ_etablissements,
	vu_fds_event_etablis_sco.nb_typ_etablis
from	vu_fds_event_alljoin_details
LEFT JOIN vu_fds_event_etablis_sco
ON  vu_fds_event_alljoin_details.num_evenement=vu_fds_event_etablis_sco.num_evenement;

ALTER TABLE vu_fds_event_etablis_sco
  OWNER TO postgres;
GRANT ALL ON TABLE vu_vds_event_alljoin TO postgres;
GRANT SELECT, INSERT, REFERENCES, TRIGGER ON TABLE vu_vds_event_alljoin TO public;
