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
