CREATE OR REPLACE VIEW vu_s_cadastre18_mf_usage AS
 SELECT s_cadastre18.gid, s_cadastre18.numparc, s_cadastre18.section, s_cadastre18.insee, s_cadastre18.idparc, s_cadastre18.codsite, s_cadastre18.the_geom, mf_usage.*
   FROM s_cadastre18, 
	(SELECT mf_generale.num_access, mf_generale.cleparc, mf_generale.code_insee, mf_generale.numr_parcelle, mf_generale.lieu_dit, mf_generale.surface, mf_generale.code_site, mf_generale.projet_acquisition, mf_generale.historisation, mf_acte_usage.*
	FROM mf_generale,
		( SELECT *
		FROM mf_acte
		WHERE mf_acte.maitrise_fonciere::text <> 'Acquisition'::text) mf_acte_usage
	WHERE  mf_generale.code_acte::text = mf_acte_usage.code_acte::text) AS mf_usage
WHERE s_cadastre18.idparc = mf_usage.cleparc::text;
