CREATE VIEW artisti_data AS SELECT max(data) FROM artista LEFT JOIN opera ON artista.artista_id=opera.artista_id GROUP BY artista.artista_id ORDER BY opera.data DESC
errore di sintassi....


select * from artisti_data order by data desc
nn vedo a cosa serve...