select R_NAME,(select SUM(W_SL) from STOCK where STOCK.W_BH=ROWNAME.R_ID) as a from ROWNAME where LOWQUANTITY>(select SUM(W_SL) as a from STOCK where STOCK.W_BH=ROWNAME.R_ID)
解决方案 »
- sql语句问题
- 交叉连接 笛卡尔积 100分! 在线等了!.........................................................................
- 一个分组查询问题,请前辈指点!!
- 100分请教一个SQL语句
- 紧急求助!!!如何让一个字段值从8321256588开始自增,谢谢!!!
- SQL,从表内容更新主表,应该怎么写,谢谢各位
- 小鸟问题,在字符串前加N是代表什么意思,有何作用
- SQL2000日志文件ERRORLOG的问题,请各位帮忙解决!
- 求教存储过程的写法
- 大家好,我想请问把一数据表备份成文本文件和从文本文件恢复的语句,谢谢大家~~~~~~~~
- 咨询一款开发工具来写脚本语句的
- 在sql server 2000的存储过程里面如何获知一行记录是否与其他表存在外键关联
from ROWNAME m , STOCK n
where m.R_ID = n.W_BH
group by m.R_NAME
having sum(n.W_SL) < m.LOWQUANTITY
from ROWNAME m , STOCK n
where m.R_ID = n.W_BH
group by m.R_NAME
having sum(n.W_SL) < m.LOWQUANTITY
from ROWNAME m , STOCK n
where m.R_ID = n.W_BH
group by m.R_NAME
having sum(n.W_SL) < m.LOWQUANTITY
消息 8121,级别 16,状态 1,第 5 行
HAVING 子句中的列 'ROWNAME.LOWQUANTITY' 无效,因为该列没有包含在聚合函数或 GROUP BY 子句中。
from ROWNAME m , STOCK n
where m.R_ID = n.W_BH
group by m.R_NAME
having sum(n.W_SL) < (select LOWQUANTITY from ROWNAME where R_ID = n.W_BH)
from ROWNAME m , STOCK n
where m.R_ID = n.W_BH
group by m.R_NAME,m.LOWQUANTITY
having sum(n.W_SL) < m.LOWQUANTITY