假设表1为table1,表2为table2select ta1.PartNo,ta2.MrQty,sum(ta2.outQty),ta2.MrQty-sum(ta2.outQty) from table1 ta1,table2 ta2 where ta1.PartNo=ta2.PartNo groupby ta1.PartNo
这样行不行: select PartNo MrQty ,sumOq,MrQty-sumOq from 表一, (select Partno,sum(OutQty) as sumOq from 表二 wher MrNo=:v_MrNo group by PartNo )表三 where (表一.MrNo=:v_MrNo) and (表一.PartNo=表三.PartNo)其中,v_MrNo 是你要指定的MR
from table1 ta1,table2 ta2
where ta1.PartNo=ta2.PartNo
groupby ta1.PartNo
select PartNo MrQty ,sumOq,MrQty-sumOq
from 表一,
(select Partno,sum(OutQty) as sumOq from 表二 wher MrNo=:v_MrNo group by PartNo )表三 where (表一.MrNo=:v_MrNo) and (表一.PartNo=表三.PartNo)其中,v_MrNo 是你要指定的MR