Torna al Thread
"SELECT C.ID_contatti, C.id_protocollo, C.id_direzione, A1.Ragione AS Mittente, A2.Ragione AS Destinatario" & _
", C.oggetto, C.messaggio, C.allegato, C.data, C.orario, C.letto" & _
" FROM (tab_archivio AS A1 INNER JOIN tab_contatti AS C ON A1.ID_Archivio = C.Mittente)" & _
" INNER JOIN tab_archivio AS A2 ON A2.ID_Archivio = C.Destinatario" & _
" ORDER BY C.data DESC, C.orario DESC"