SET @cJobNo = '11708' SELECT TimeHD.Empid, TimeHD.EmpName, sum(regtime) as RegTime,sum(overtime) as OverTime, Sum(doubletime) as DoubleTime, sum(regtime+overtime+doubletime) as TotalHours1 FROM TimeHd INNER JOIN TimeItms ON TimeHd.timecrdno = TimeItms.timecrdno Where TimeItms.JobNo = @cJobNo and TimeItms.[distributed] <> 1 group by TimeHD.Empid, TimeHD.EmpName UNION ALL SELECT TimeHD.Empid, TimeHD.EmpName, sum(regtime) as RegTime,sum(overtime) as OverTime, Sum(doubletime) as DoubleTime, sum(regtime+overtime+doubletime) as TotalHours1 FROM TimeHd INNER JOIN TimeItms ON TimeHd.timecrdno = TimeItms.timecrdno Where TimeItms.JobNo = @cJobNo and TimeItms.[distributed] = 1 group by TimeHD.Empid, TimeHD.EmpName order by empidI've tried switching the where clauses around but it doesn't seem to matter. Any ideas?