SELECT  DISTINCT ON (spatial.bdp_commune.gid)
	spatial.bdp_commune.gid,
	spatial.sites_emprise.codsit,
	spatial.sites_emprise.nom_site,
	spatial.bdp_commune.code_insee,
	spatial.bdp_commune.nom_com,
	spatial.bdp_commune.geom
from spatial.bdp_commune, spatial.sites_emprise
where  ST_Overlaps (spatial.bdp_commune.geom, spatial.sites_emprise.geom)
ORDER BY spatial.bdp_commune.gid;