22,209
社区成员
发帖
与我相关
我的任务
分享
Select FAuxQtypass as a,FAuxQtyscrap as b,FAuxQtyForItem as c,a1.标准机器运行总工时 as d,FfixTime as E,* from shprocrptMain v1
INNER JOIN shprocrpt u1 ON v1.FInterID = u1.FInterID AND u1.FInterID<>0
inner join(
select FMachStdTimeRun as 标准机器运行总工时,t2.FitemID as FitemID,FOperID,FNumber from t_RoutingGroup t1
inner join t_Routing t2 on t1.FInterID=t2.FParentID
inner join t_RoutingOper t3 on t2.FInterID=t3.FInterID
) a1 on v1.FOperID=a1.FOperID and v1.FItemID=a1.FitemID
where 1=1 AND (v1.FTranType=582) order by v1.FBillNo