17,078
社区成员
发帖
与我相关
我的任务
分享
select t1.wonum,t1.woline,item,revision,compitem,compitemrev,ord_qty,qty from
(select wonum,woline,item,revision,sum(ord_qty) ord_qty from table1 group by wonum,woline,item,revision)t1,
(select wonum,woline,compitem,compitemrev,sum(qty) qty from table2 group by wonum,woline,compitem,compitemrev) t2
where t1.wonum=t2.wonum and t1.woline=t2.woline;