SELECT mf_generale.*,
 spatial.bdp_localisant.gid,
 spatial.bdp_localisant.geom
FROM mf_generale
JOIN spatial.bdp_localisant
ON bdp_localisant.cleparc::text =mf_generale.cleparc::text;