SELECT e.denominazione, a.email FROM tbl_addetti a
inner join tbl_editori e on a.editoreId=e.casaEditriceId
where coalesce(a.email, '') != ''
order by e.denominazione, a.email
