select a.idNews, a.titoloIT, a.testoIT, b.nomeIT as categoria, a.dataIns, b.idCategoria from news a left join news_categorie b on(a.idCategoria = b.idCategoria) where idNews='1' Hotel Ristorante Croce Bianca - Asiago