[SQL] Prendere l'ultimo record inserito per data

[brovez]

prova con

SELECT PLW_MAT.matricola, PLW_MAT.modello, PLW_MAT.tipofat, max(PLW_LET.data) as maxdata, PLW_LET.letnero, PLW_LET.letcolori
FROM PLW_MAT INNER JOIN PLW_LET ON PLW_MAT.idmat = PLW_LET.idmat
WHERE PLW_MAT.idana =[ID]
GROUP BY PLW_MAT.matricola, PLW_MAT.modello, PLW_MAT.tipofat, PLW_LET.letnero, PLW_LET.letcolori ;