UC知道那个高手能给我翻译一下，这段ASP什么意思？
来源：百度知道 编辑：UC知道 时间：2024/06/09 06:57:16
sql = "SELECT top 5 [article].[articleid], [article].[title], [article].[dateandtime], [article].[hits], [article].[classid], [article].[Nclassid], [ANclass].[Nclass] FROM ANclass INNER JOIN article ON [ANclass].[Nclassid]=[article].[Nclassid] where article.NclassID = " & NclassID & " ORDER BY [article].[articleid] DESC"
select top 5 选择前五条
[article].[articleid], [article].[title], [article].[dateandtime], [article].[hits], [article].[classid], [article].[Nclassid], [ANclass].[Nclass]
列名 加表前缀.
FROM ANclass INNER JOIN article ON [ANclass].[Nclassid]=[article].[Nclassid] where article.NclassID = " & NclassID & " 两个表联合查询 以[ANclass].[Nclassid]=[article].[Nclassid]作为条件。
ORDER BY [article].[articleid] DESC 按[article].[articleid]列升序显示。