Question

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 请帮助看一下，谢谢。

Answer 1

把from (lodo_activity_goods_list left join
lodo_Goods on lodo_Goods.ID=lodo_activity_goods_list.gid) where
这一段中间的括号去掉试试。

Answer 2

加个Order By

Answer 3

你去掉from后面的括号试一下

Answer 4

去掉 SQL:

Answer 5

没发现有问题，除非数据库不支持top,什么数据库啊？
SqlServer吗？