T_SQL语句在sql2000中运行正常，但是在ACCESS中报错

[sdhqian]

查询语句如下：

SELECT Users.id, Users.PointId AS 站长ID, Users.PointName AS 站长姓名,
Users.QQorMSN AS QQ或者MSN, Users.Tel AS 电话号码,
Users.NetName AS 网站名称, Products.ProductName AS 产品名称,
PType.TypeName AS 产品类型, Users.ProductPrice AS 产品单价,
Users.ProductFlow AS 产品流量, Users.ProductBehind AS 产品链接,
Users.BehindHref AS 后台链接, Users.StartDate AS 开始时间,
Users.StopDate AS 结束时间, Users.TotalMoney AS 总计金额
FROM Users INNER JOIN
Products ON Users.ProductID = Products.ProductID INNER JOIN
PType ON PType.TypeId = Users.ProductTypeId
ORDER BY Users.PointName

实在找不出原因，请高手指教，谢谢啦！！

[sdhqian]

我把你的语句运行了一遍，还是有报错，错误还是语法错误（操作符丢失）

[C_sdnElf]

FROM Users ?

[zhiha258]

为什么要用在ACESS....

[cqq]

报什么错误呢？

[51Crack]

[Quote=引用 3 楼 C_sdnElf 的回复:]
FROM Users ?
[/Quote]
FROM [Users]

[koukoujiayi]

语法上看不出有任何错!!
要么是字段名错了?

[tgbd]

你三个表中分别取一个字段，一步步测，看看问题出来哪里。

[xray2005]

把Users 改成 [Users]

[apollolb2005]

你可以自己想办法尝试下查找错误在哪里

比如
SELECT Users.*
FROM Users INNER JOIN
Products ON Users.ProductID = Products.ProductID INNER JOIN
PType ON PType.TypeId = Users.ProductTypeId
ORDER BY Users.PointName

如果没问题，那错误就在前面