Hello Shaun, > 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
Try: LEFT JOIN Projects P ON (P.Project_ID = T.Project_ID and T.Date >= '2004-10-18' AND T.Date <= '2004-10-24') WHERE T.User_ID = "1" AND T.Type = "Project" > 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 | > +------------+-------+--------------+ With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
