Oracle两个表关联的别名的问题

Question

        投料数量+调节数量  别名成计划数量        收货数量       计划数量-收货数量=未收货数量
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
求解 在线等

Answer 1

有问题么？
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

Answer 2

---这样不就行了
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

Answer 3

select (b.WMS_ITEM_COUNT+b.WMS_TJCOUNT) jhsl ,a.RECEIVE_QTY,(jhsl-a.RECEIVE_QTY) wssl from WMS_STOCK_DTL b,WMS_U_ZHIGREEORD a
where b.wms_item_code=a.material_code我别名该了 然后用jhsl 弹出 无效列名我在未收货的时候 要用计划数量-收货数量

Answer 4

select (b.WMS_ITEM_COUNT+b.WMS_TJCOUNT) as jhsl ,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-or嵌套

Answer 5

select jhsl,RECEIVE_QTY,(jhsl-a.RECEIVE_QTY) 未收货数量
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)

Answer 6

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