大家帮我看一下这个SQL语句有什么问题,该怎么改?

dxl1949 2006-03-09 12:21:19

sqlStr = "select count(TechID) from TechRsltTbl " & "Union select count(TechID) from TechRsltTbl where sum(StuTyp)/sum(num)>90 Group by TechID"

rs.Open sqlStr, conn, adOpenStatic, adLockOptimistic
...全文
50 点赞 收藏 4
写回复
4 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
qybao 2006-03-09
have a try
sqlStr = "select count(TechID) from TechRsltTbl " & "Union select sumTechID from (select TechID, count(TechID) as sumTechID from TechRsltTbl where sum(StuTyp)/sum(num)>90 Group by TechID)"
回复
flyingscv 2006-03-09
sqlStr = "select * from TechRsltTbl "

rs.Open sqlStr, conn, adOpenStatic, adLockOptimistic

匿了
回复
dxl1949 2006-03-09
怎么还人回答
回复
dxl1949 2006-03-09
还是不行啊
回复
相关推荐
发帖

1187

社区成员

VB 数据库(包含打印,安装,报表)
申请成为版主
帖子事件
创建了帖子
2006-03-09 12:21
社区公告
暂无公告