Cut and paste bites me again. The <table reference> portion (cut out
accidentally) should have been:
FROM Weeks w
LEFT Bookings b
on WEEK(b.Booking_Start_Date) = w.Week_Number
LEFT JOIN Projects p
ON p.Project_Id = b.Project_ID
sorry all!
Shawn
[EMAIL PROTECTED] wrote on 05/23/2005 12:20:05 PM:
> "shaun thornburgh" <[EMAIL PROTECTED]> wrote on 05/23/2005
> 10:18:29 AM:
>
> > Hi,
> >
> > The following query produces the number of bookings per project
grouped
> by
> > week:
> >
<snip>
> ... That means the <table reference>
> portion of your query should look like
>
>
>
> And that means your whole query translates to:
>
<snip>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
