mysql - 这个 mysql 代码产生语法错误，我不知道为什么

Question

select EMP_LNAME  from Employee where EMP_DOB -0 > 19700000 LEFT OUTER JOIN Store ON Employee.STORE_CODE = Store.STORE_CODE NATURAL JOIN Region where REGION_DESCRIPT = 'East';

这段代码会导致 mysql 出现 1024 错误，我不知道为什么。有什么想法吗？

Answer 1

你的语法错误。语法必须是 select ... from ... join ... on ... where 试试这个:

select EMP_LNAME  from Employee  LEFT OUTER JOIN Store ON Employee.STORE_CODE = Store.STORE_CODE NATURAL JOIN Region where EMP_DOB -0 > 19700000 and REGION_DESCRIPT = 'East';