带有 JOIN 和 WHERE 子句的 MySQL 查询不起作用

Question

我正在尝试使 MySQL 查询正常工作，但一直出现错误。我想用 WHERE 子句连接两个表 tbl_collab 和 tbl.uploads 但无法弄清楚我哪里错了。谢谢。

 SELECT tbl_collab.collab_userid, tbl_collab.file, tbl_collab.tbl_upload_id,
    tbl_uploads.id,tbl_uploads.title,
    FROM tbl_uploads
    LEFT JOIN tbl_uploads.id ON tbl_collab.tbl_upload_id
WHERE tbl_collab.collab_userid='2'

我收到这个错误:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM tbl_uploads LEFT JOIN tbl_uploads.id ON tbl_collab.tbl_upload_id WHERE ' at line 3

Answer 1

from 和 left join 之后的整个语法是错误的。请根据以下查询更新它。

试试这个:

SELECT tbl_collab.collab_userid, 
       tbl_collab.file, 
       tbl_collab.tbl_upload_id, 
       tbl_uploads.id, 
       tbl_uploads.title
FROM tbl_collab 
LEFT JOIN tbl_uploads ON tbl_uploads.id = tbl_collab.tbl_upload_id
WHERE tbl_collab.collab_userid='2'