mysql query with output to cvs -- 2

I have two queries I am looking to combine. I will like the the output to match the attached spreadsheet. I have also attached tables. SELECT [login to view URL] AS Employee, SEC_TO_TIME(SUM(TIME_TO_SEC(CONCAT(teight,':',teightb)) - TIME_TO_SEC(CONCAT(tseven,':',tsevenb)))) AS TotalHours FROM schedule WHERE [login to view URL] BETWEEN '2014-08-29' AND '2014-08-29' GROUP BY custno SELECT regular, employee FROM timesheet WHERE [login to view URL] between '2014-08-29' AND '2014-08-29' GROUP BY employee Update: I have one query but I have this trouble: One problem if you run this query you will see total hours says 10 for all but 1 of the result should be 12. SELECT [login to view URL],[login to view URL],MIN([login to view URL]),MAX([login to view URL]),SEC_TO_TIME(SUM([login to view URL])) AS total_hours,[login to view URL],TIMEDIFF(SEC_TO_TIME(SUM([login to view URL])),[login to view URL]) AS bil FROM( SELECT [login to view URL], [login to view URL],[login to view URL],[login to view URL],t.`regular`,TIME_TO_SEC(TIMEDIFF([login to view URL],[login to view URL])) AS total FROM schedule AS s LEFT JOIN timesheet AS t ON ([login to view URL] = [login to view URL] AND s.date=[login to view URL]) )a WHERE a.date='2014-08-29' GROUP BY [login to view URL],[login to view URL];