Access数据库中的双重内部联接

Access数据库中的双重内部联接

你用括号试过了吗？MS Access需要在多个JOINS周围加上（即喜欢）括号：

 SELECt     Task_Id, e2.emploeey_name AS W_FROM, e1.emploeey_name AS W_TO, t.Task_Details FROM        (      tasks AS T      INNER JOIN Employees AS e1 ON e1.Emploeey_id = T.Task_To ) INNER JOIN Employees AS e2       ON e2.Emploeey_id = T.write_From