- SELECT a.title,a.imageName, i.imagename as articleimage, a.author FROM article a left outer join articleImage i on i.articleid=a.articleid where a.articleid = 101412