sql - 基本的 SQL 东西……左连接

Question

我是 SQL 新手。这没有返回任何结果......

SELECT media.id as mediaid, media.title as mediatitle, 
  media.description as mediadescription, media.date as mediadate, 
  media.duration, media.price as mediaprice, media.thumburl as thumburl, 
  presenters.f_name as firstname, presenters.l_name as lastname, 
  presenters.credentials 
FROM `media` 
WHERE media.title = 'Code of Ethical Conduct' 
LEFT JOIN `presenters` ON presenters.fkMediaID = media.id

但在我添加演示者部分之前，它工作得很好......

SELECT media.id as mediaid, media.title as mediatitle, 
  media.description as mediadescription, media.date as mediadate, 
  media.duration, media.price as mediaprice, media.thumburl as thumburl 
FROM `media` 
WHERE media.title = 'Code of Ethical Conduct'

有什么想法吗？

Answer 1

WHERE 子句放在最后

所以它将是 FROM media LEFT JOIN Presenters .....

WHERE media.title ....