Re: Counting Entries

2005-09-01 Thread Shaun
<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Shaun" <[EMAIL PROTECTED]> wrote on 09/01/2005 05:38:01 AM: > > >> >> The corrected query should read: >> >> SELECT m.name as month, YEAR(b.Booking_Start_Date) as year, >> >> COUNT(b.Booking_ID) AS "Num_Bookings" >> >> FROM monthList

Re: Counting Entries

2005-09-01 Thread SGreen
"Shaun" <[EMAIL PROTECTED]> wrote on 09/01/2005 05:38:01 AM: > >> The corrected query should read: > >> SELECT m.name as month, YEAR(b.Booking_Start_Date) as year, > >> COUNT(b.Booking_ID) AS "Num_Bookings" > >> FROM monthList m > >> LEFT JOIN Bookings b > >>ON m.id = MONTH(b.Booking_Star

Re: Counting Entries

2005-09-01 Thread Shaun
""Shaun"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] >> "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 04:56:23 PM: >> >>> >>> <[EMAIL PROTECTED]> wrote in message >>> >> news:[EMAIL PROTECTED] >>> > "Shaun" <[EM

Re: Counting Entries

2005-08-31 Thread Shaun
<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 04:56:23 PM: > >> >> <[EMAIL PROTECTED]> wrote in message >> > news:[EMAIL PROTECTED] >> > "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 04:04:20 PM: >> > >> >> >> >> <[EMAIL PROTECTED]

Re: Counting Entries

2005-08-31 Thread SGreen
"Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 04:56:23 PM: > > <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 04:04:20 PM: > > > >> > >> <[EMAIL PROTECTED]> wrote in message > >> > > news:[EMAIL PROTECTED] > >> > "Shaun" <[EM

Re: Counting Entries

2005-08-31 Thread Shaun
<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 04:04:20 PM: > >> >> <[EMAIL PROTECTED]> wrote in message >> > news:[EMAIL PROTECTED] >> > "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 02:43:33 PM: >> > >> >> Hi, >> >> >> >> This que

Re: Counting Entries

2005-08-31 Thread Oliver Smith
[EMAIL PROTECTED] wrote: If that wasn't it, can you explain WHY those numbers are wrong as I have only the slimmest clue what your data is supposed to look like. If those aren't the numbers you wanted, what numbers did you expect? Please, provide sample queries to demonstrate what you expected

Re: Counting Entries

2005-08-31 Thread SGreen
"Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 04:04:20 PM: > > <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 02:43:33 PM: > > > >> Hi, > >> > >> This query counts the number of entries in the Bookings table per month, > > is

Re: Counting Entries

2005-08-31 Thread Shaun
<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 02:43:33 PM: > >> Hi, >> >> This query counts the number of entries in the Bookings table per month, > is >> it possible for this query to return a zero where there are no entries > for a

Re: Counting Entries

2005-08-31 Thread SGreen
"Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 02:43:33 PM: > Hi, > > This query counts the number of entries in the Bookings table per month, is > it possible for this query to return a zero where there are no entries for a > particular month? > > SELECT COUNT(Booking_ID) AS "Num_Bookings"

Counting Entries

2005-08-31 Thread Shaun
Hi, This query counts the number of entries in the Bookings table per month, is it possible for this query to return a zero where there are no entries for a particular month? SELECT COUNT(Booking_ID) AS "Num_Bookings" FROM Bookings WHERE User_ID = 1 AND Work_Type_ID = 12 AND DATE_FORMAT(Booking