Sql="Select top 10 from pub_article where arttype="&TempArray(0,i)&" and boardid="&PUB_GFGS_ID&" order by builddate desc"



有问题吗这个语句
输出语句是这样的 Select top 10 from pub_article where arttype=1200 and boardid=12 order by builddate desc

错误提示是
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]在关键字 'from' 附近有语法错误。
请指教

sql ="Select top 10 from pub_article where arttype='" & TempArray(0,i) &"' and boardid ='" & PUB_GFGS_ID & "' order by builddate desc"

Sql="Select top 10 * from pub_article where arttype="&TempArray(0,i)&" and boardid="&PUB_GFGS_ID&" order by builddate desc"
缺少字段名称

楼上正解