mysql - 从加入中选择时出错

Question

有谁知道为什么我从此查询中收到错误:

SELECT COUNT(*) 
FROM individual AS i LEFT JOIN establishment AS e USING establishment_id
WHERE i.bla = e.bla;

mysql-workbench 在第 1 行的 setup_id 下给了我一条波浪线，并报告语法错误，但我不确定为什么会收到此错误。

Answer 1

我认为你需要括号:

SELECT COUNT(*) 
FROM individual AS i LEFT JOIN establishment AS e USING (establishment_id)
WHERE i.bla = e.bla;