投料数量+调节数量 别名成计划数量 收货数量 计划数量-收货数量=未收货数量
select (b.WMS_ITEM_COUNT+b.WMS_TJCOUNT) as jhsl ,a.RECEIVE_QTY,(jhsl-a.RECEIVE_QTY) from WMS_STOCK_DTL b,WMS_U_ZHIGREEORD a
where b.wms_item_code=a.material_code
求解 在线等
select (b.WMS_ITEM_COUNT+b.WMS_TJCOUNT) as jhsl ,a.RECEIVE_QTY,(jhsl-a.RECEIVE_QTY) from WMS_STOCK_DTL b,WMS_U_ZHIGREEORD a
where b.wms_item_code=a.material_code
求解 在线等
解决方案 »
- 求助,ORACLE PL/SQL 万思不得其解的问题
- 为什么没有PROCEDURE_NAME呢
- oracle 模糊查询问题
- 触发器的问题 高手请进
- 求教:LinuxRedhatAS4上rpm安装Oracle10后不能启动
- 请教,下面的sql 如何写
- 请帮忙看看我的源码:为什么使用触发器更新父表汇总数据时,出错了呢?
- 分不在多,心成则灵!请问何种权限的用户才能够从登陆 oracle dba studio登陆? help!
- 非常复杂的SQL语句,邀高手优化.我在线测试优化结果.并公布之,分数不是问题.
- oracle
- 关于表中相同字段相加的问题
- 各位大侠 oracle报违反协议(ORA-17401协议冲突
select (b.WMS_ITEM_COUNT+b.WMS_TJCOUNT) 计划数量 ,a.RECEIVE_QTY 收货数量,(b.WMS_ITEM_COUNT+b.WMS_TJCOUNT-a.RECEIVE_QTY) 未收货数量
from WMS_STOCK_DTL b,WMS_U_ZHIGREEORD a
where b.wms_item_code=a.material_code
select (b.WMS_ITEM_COUNT+b.WMS_TJCOUNT) jhsl ,a.RECEIVE_QTY shsl,(jhsl-a.RECEIVE_QTY) mshsl from WMS_STOCK_DTL b,WMS_U_ZHIGREEORD a
where b.wms_item_code=a.material_code
where b.wms_item_code=a.material_code我别名该了 然后用jhsl 弹出 无效列名我在未收货的时候 要用计划数量-收货数量
(b.WMS_ITEM_COUNT+b.WMS_TJCOUNT-a.RECEIVE_QTY)
from WMS_STOCK_DTL b,WMS_U_ZHIGREEORD a
where b.wms_item_code=a.material_code-or嵌套
from (select (b.WMS_ITEM_COUNT+b.WMS_TJCOUNT) as jhsl ,a.RECEIVE_QTY
from WMS_STOCK_DTL b,WMS_U_ZHIGREEORD a
where b.wms_item_code=a.material_code)
where b.wms_item_code=a.material_code