Access 2000 中4个以上的表外关联查询问题， 3个可以做到，4个就不行了， why? 请看看这段代码

[Auto_And_Elec]

Access 2000, Win2000 pro

Select * from t1 left join (t2 left join t3 on t2.id = t3.id) on t1.id = t2.id;
这段可以执行成功。

但是4个表或者更多：
select * from t1 left join (t2 left join ( t3 left join t4 on t3.id = t4.id) on t2.id = t3.id) on t1.id=t3.id;
却提示语法有错，请问这是为什么？

谢谢

[small_wei]

嵌套太多？

[databasesql]

SELECT *
FROM (((t1 INNER JOIN t2 ON t1.ID = t2.ID) INNER JOIN t3 ON (t2.ID = t3.ID) AND (t1.ID = t3.ID)) INNER JOIN t4 ON (t2.ID = t4.ID) AND (t1.ID = t4.ID)) INNER JOIN t5 ON (t2.ID = t5.ID) AND (t1.ID = t5.ID);