mysql - 在数据库SQL中测试时查询错误

Question

我有这个查询，但它似乎有问题？我正在尝试将 fices 与 mems 结合起来，这样我就可以获得 ficeID 以及 mems 的所有结果(这些查询单独工作)。我做错了什么？

  SELECT * 
    FROM mems 
   WHERE deleted <> -1 
ORDER BY sort_mems 
         LEFT JOIN SELECT ficeID 
                     FROM fices

结果:

 #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 'LEFT JOIN SELECT ficeID FROM offices LIMIT 0, 30' at line 1

Answer 1

• 在 ORDER BY 之后有 JOIN 子句。您应该将其放在 FROM 中。
• 我建议您定义LEFT JOIN的条件

• 此外，我建议您用方括号将临时表括起来:

    SELECT m.*, t1.officeID
      FROM members m
           LEFT JOIN offices t1
                     ON m.memberID = t1.memberID
     WHERE m.deleted <> -1 
  ORDER BY m.sort_membername;