SELECT native.enum, native.lineid, native.OPseqnum, native.OPoperationcode, (SELECT MAX(DayATTMINS) FROM vw_day_weekly_day_summed WHERE vw_day_weekly_day_summed.enum = native.enum AND vw_day_weekly_day_summed.lineid = native.lineid) AS DayATTMINS, (SELECT MAX(DayCONTMINS) FROM vw_day_weekly_day_summed WHERE vw_day_weekly_day_summed.enum = native.enum AND vw_day_weekly_day_summed.lineid = native.lineid) AS DayCONTMINS, native.DayOVTMINS, native.DayABSMINS, (SELECT MAX(DayTOTSMS) FROM vw_day_weekly_day_summed WHERE vw_day_weekly_day_summed.enum = native.enum AND vw_day_weekly_day_summed.lineid = native.lineid) AS DayTOTSMS, native.DayUMW, native.DayUJ, native.DaySMP, native.DayEH, (SELECT MAX(DayOffStdMins) FROM vw_day_weekly_day_summed WHERE vw_day_weekly_day_summed.enum = native.enum AND vw_day_weekly_day_summed.lineid = native.lineid) AS DayOffStdMins, (SELECT MAX(DayOffStdSMS) FROM vw_day_weekly_day_summed WHERE vw_day_weekly_day_summed.enum = native.enum AND vw_day_weekly_day_summed.lineid = native.lineid) AS DayOffStdSMS, native.DayWT, native.DayMB, native.DayRPS, native.DayDR, native.DayC, native.DayNPTMins, (SELECT MAX(DayOnStdMins) FROM vw_day_weekly_day_summed WHERE vw_day_weekly_day_summed.enum = native.enum AND vw_day_weekly_day_summed.lineid = native.lineid) AS DayOnStdMins, (SELECT MAX(DayOnStdSMS) FROM vw_day_weekly_day_summed WHERE vw_day_weekly_day_summed.enum = native.enum AND vw_day_weekly_day_summed.lineid = native.lineid) AS DayOnStdSMS, (SELECT MAX(DayEff) FROM vw_day_weekly_day_summed WHERE vw_day_weekly_day_summed.enum = native.enum AND vw_day_weekly_day_summed.lineid = native.lineid) AS DayEff, (SELECT MAX(DayUtl) FROM vw_day_weekly_day_summed WHERE vw_day_weekly_day_summed.enum = native.enum AND vw_day_weekly_day_summed.lineid = native.lineid) AS DayUtl, tab_sys_companyparameters.startdate, tab_sys_companyparameters.enddate, tab_per_personnel.name, tab_op_operatons.description, tab_sec_section.sid, tab_fac_factory.fid, tab_fac_factory.factorydescription, tab_sec_section.sectiondescription, tab_lin_line.linedescription, native.OPqty, tab_op_operatons.SMV, tab_sys_companyparameters.lowperf, tab_sys_companyparameters.hiperf, tab_lin_line.lid, tab_per_personnel.OperatorClass, native.DayBN, native.DayMBE, tab_lin_line.lineseqFROM tab_sys_companyparameters CROSS JOIN vw_day_weekly_day_summed native INNER JOIN tab_per_personnel ON native.enum = tab_per_personnel.employeenumber INNER JOIN tab_sec_section INNER JOIN tab_lin_line ON tab_sec_section.sid = tab_lin_line.sid INNER JOIN tab_fac_factory ON tab_sec_section.fid = tab_fac_factory.fid ON native.lineid = tab_lin_line.lid LEFT OUTER JOIN tab_op_operatons ON native.OPoperationcode = tab_op_operatons.opcode