On 15/09/06, Brad Bonkoski <bbonkoski@xxxxxxxxxxxxxx> 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.