34,593
社区成员
发帖
与我相关
我的任务
分享
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)
select m.R_NAME , sum(n.W_SL) W_SL
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
select m.R_NAME , sum(n.W_SL) W_SL
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)
select m.R_NAME , sum(n.W_SL) W_SL
from ROWNAME m , STOCK n
where m.R_ID = n.W_BH
group by m.R_NAME
having sum(n.W_SL) < m.LOWQUANTITY
select m.R_NAME , sum(n.W_SL) W_SL
from ROWNAME m , STOCK n
where m.R_ID = n.W_BH
group by m.R_NAME
having sum(n.W_SL) < m.LOWQUANTITY