你用括号试过了吗?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