Sql出错:第 1 行: '3' 附近有语法错误.

SQL:select top 3
lodo_goods.ID,lodo_goods.GoodsName,lodo_goods.GoodsCode,lodo_goods.Quantity,lodo_goods.LittlePursue,lodo_Goods.GoodsBriefIntroduction,lodo_goods.CurrentPriceOnMarketstr,lodo_goods.PriceOfOurStationstr,lodo_goods.CurrentPriceOnMarket,lodo_goods.PriceOfOurStation,lodo_activity_goods_list.Discount,lodo_activity_goods_list.minbuysum,lodo_activity_goods_list.maxbuysum,lodo_activity_goods_list.maxqn,lodo_activity_goods_list.ID
as gaid,lodo_activity_goods_list.ClickCount as
ClickCount,lodo_activity_goods_list.u_buyqn as
u_buyqn,lodo_goods.GoodsUnit from (lodo_activity_goods_list left join
lodo_Goods on lodo_Goods.ID=lodo_activity_goods_list.gid) where
lodo_activity_goods_list.aid=1

Sql出错:第 1 行: '3' 附近有语法错误。
查询数据的时候发现错误,请检查您的查询代码是否正确。 这个是什么意思,是哪里错了吗?

这个ld_scarebuying.asp 文件地址是:
http://z.edures.bjedu.cn/zyw/ld_scarebuying.txt 请帮助看一下,谢谢。

第1个回答  2014-06-19
把from (lodo_activity_goods_list left join
lodo_Goods on lodo_Goods.ID=lodo_activity_goods_list.gid) where
这一段中间的括号去掉试试。
第2个回答  2014-06-19
加个Order By
第3个回答  2014-06-19
你去掉from后面的括号试一下
第4个回答  2014-06-19
去掉 SQL:
第5个回答  2014-06-19
没发现有问题,除非数据库不支持top,什么数据库啊?
SqlServer吗?