Monday, April 4, 2016

Join with more than 2 tables

select posts.posttitle, posts.postbody, authors.authorName, authors_info.`key`, authors_info.`value`  from posts left join authors
on  posts.authorId=authors.authorId
left join authors_info on authors.authorId=authors_info.authorid