codice:
select id,notizia,campo_data as dat from
tabella1
union all
select id,notizia,campo_data as dat from
tabella2
union all
select id,notizia,campo_data as dat from
tabella3
order by dat desc limit 1