SELECT DISTINCT T0.Jobcard, T0.Operator, T1.JobCardQty, T0.Mouldqty, T0.Process, T0.Profilename, T0.Remark, T0.Date, T1.U_od, T0.Supervisor, T2.SizeFrom, T2.SizeTo, (T0.Mouldqty * T2.Rate + T2.DieSetting) AS Cost, T3.Division FROM SAPProduction.ProductionData AS T0 INNER JOIN SAPProduction.RateChartData AS T1 ON T0.Jobcard = T1.Jobcard COLLATE SQL_Latin1_General_CP850_CI_AS INNER JOIN SAPProduction.ProductionRateTable AS T2 ON T0.Process = T2.Process INNER JOIN SAPProduction.ProductionMaterialMaster AS T4 ON T2.Process = T4.process INNER JOIN SAPProduction.ProductionDivisionMaster AS T3 ON T2.ChartType = T3.fid WHERE (T1.U_od BETWEEN T2.SizeFrom AND T2.SizeTo)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)