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