在access db中运行多连接有问题吗？

Question

我试图在access中运行此sql语句，并发现语法错误。

Select  * 
from TableC C INNER JOIN TableE E 
on E.TKey = C.TKey
INNER JOIN TableP P on P.TKey = E.TKey  AND E.employee_id = '123' 

错误：

syntax error(missing operator) in query expression 'E.TKey = C.TKey
    INNER JOIN TableP P on P.TKey = E.TKe'

Answer 1

在access中，如果不使用括号将它们分隔开，就不能有多个联接。

Select  * 
from (TableC C 
INNER JOIN TableE E 
on E.TKey = C.TKey)
INNER JOIN TableP P 
on P.TKey = E.TKey  
AND E.employee_id = '123';