SELECT sites.code_site, sites.ref_carto, s_sites_niv1."CODSIT", s_sites_niv1."REFNUM"
FROM sites,s_sites_niv1
WHERE sites.code_site=s_sites_niv1."CODSIT" AND s_sites_niv1."REFNUM"='scan25'
