Q&A about the site for expert genealogists and people interested in genealogy or family history
SELECT p.Id, p.PostTypeId, pt.Name FROM posts AS p LEFT JOIN PostTypes AS pt ON pt.Id = p.PostTypeId