Ho fatto così:

SELECT DISTINCT *, MAX(data) AS d FROM nomi AS N LEFT JOIN azioni AS A ON N.id = A.idn GROUP BY N.id

grazie
ciao