复制select isnull(s.mnumber,据库决ss.mnumber) mnumber,isnull(m.whcode,ss.whcode) whcode, isnull(sum(factreceiptquan),0)-isnull(sum(factissuequan),0) + sum(isnull(ss.quan,0)) quan from (select * from gy_inoutmain where billcode in(1201,1202,1203,1204,1205,1206) ) m inner join gy_inoutsub s on m.inoutmainid=s.inoutmainid left join( select sms.mnumber,sm.whcode,sum(sms.quan) quan from Kf_StartMain sm inner join Kf_Startsub sms on sm.startmainid=sms.startmainid group by sm.whcode,sms.mnumber ) ss on m.whcode=ss.whcode and s.mnumber=ss.mnumber group by isnull(m.whcode,ss.whcode),isnull(s.mnumber,ss.mnumber) order by s.mnumber 1.2.3.4.5.6.7.8.9.10. |
喜欢
讨厌