-+
10 rows in set (0.00 sec)
mysql>
Any ideas?
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: SELECTING Non existing Dates
Date: Wed, 20 Oct 2004 15:10:51 +0200
Hello Shaun,
> I have query that I am using to try to get the number
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] writes:
> With a LEFT JOIN you will get back your "zero hours" only if there exist
> records in the Timesheets table that match no records in the projects
> table. If you have no Timesheets data for the 23rd or 24th, then you
> can't have any r
With a LEFT JOIN you will get back your "zero hours" only if there exist
records in the Timesheets table that match no records in the projects
table. If you have no Timesheets data for the 23rd or 24th, then you
can't have any rows in your results for those dates. MySQL won't fill in
the miss
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.Dat
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