Hi,
I have query that I am using to try to get the number of hours worked and on which project by an employee during a particular week. Here is the query:
SELECT T.Date, T.Hours, P.Project_Name FROM Timesheets T LEFT JOIN Projects P ON P.Project_ID = T.Project_ID WHERE T.Date >= "2004-10-18" AND T.Date <= "2004-10-24" AND T.User_ID = "1" AND T.Type = "Project" GROUP BY T.Date, T.Project_ID ORDER BY T.Date
And here is the result:
+------------+-------+--------------+ | Date | Hours | Project_Name | +------------+-------+--------------+ | 2004-10-18 | 4 | Project A | | 2004-10-18 | 3 | Project B | | 2004-10-19 | 3 | Project A | | 2004-10-19 | 5 | Project B | | 2004-10-20 | 4 | Project A | | 2004-10-20 | 3 | Project B | | 2004-10-21 | 1 | Project A | | 2004-10-21 | 7 | Project B | | 2004-10-22 | 2 | Project A | | 2004-10-22 | 6 | Project B | +------------+-------+--------------+
All is working fine except I would like the query to show zero values for days where there are no entries i.e. the 23rd and 24th in this example. I thought that the LEFT JOIN would achieve this but unfortunately not! If someone could show me where I am going wrong I would be most grateful.
Many thanks,
Shaun
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]