codice:
select b.codsoc AS codsocieta , e.codsoc AS codsocietaesplo , b.denominazione AS denomi from bilanci_pres as b
left join esplo_bil as e
on b.codsoc = e.codsoc
where e.codsoc is null