SELECT research.research_id, research.article_id, research.question, research.answer1, research.answer2, research.answer3, DATE_FORMAT( research.entry_date, '%Y/%m/%d %H:%i:%s' ) as entry_date, DATE_FORMAT( research.update_date, '%Y/%m/%d %H:%i:%s' ) as update_date, article.article_id, article.title, article.view_name, article.valid_flg, research.valid_flg FROM research LEFT JOIN article ON research.article_id = article.article_id WHERE research.valid_flg <> 0 AND article.valid_flg <> 0 AND article.dev_flg = 0 Table 'sana-type_records.research' doesn't exist