On 15/09/06, Brad Bonkoski <[EMAIL PROTECTED]> wrote:

Have you tried echoing out your query to run on the backend itself?
Maybe there is some problem with how your join is being constructed...
Perhaps a left outer join is called for?  Hard to tell without having
knowledge of your table structure and table data...

Yep, I've echoed it and it says:

"...WHERE dates.date = '2006-10-03'..."

I think you're right on the join stakes, I will investigate further, many
thanks and have a great weekend.

Reply via email to