| | |
| | | ,b.HSourceInterID,b.HSourceEntryID,b.HSourceBillNo,b.HSourceBillType |
| | | from Sc_ProcessReportMain a |
| | | inner join Sc_ProcessReportSub b on a.HInterID=B.HInterID |
| | | inner join (select max(HProcNo) HProcNo |
| | | inner join (select max(HProcNo) HProcNo,max(HProcID) HProcID |
| | | from Sc_ProcessPlanSub group by HBillNo,HSourceBillNo) |
| | | pr on b.HProcID=pr.HProcNo |
| | | pr on b.HProcID=pr.HProcID |
| | | left join Gy_Process p on b.HProcID=p.HItemID |
| | | left join Gy_Material m on a.HMaterID=m.hitemid |
| | | left join Gy_Source s on b.HSourceID=s.HItemID |