Hi,
Thanks for your reply Peter. Each booking is based on a particular project by Project_ID. Is it possible to modify the query such that the projects are listed in turn? For example:
Jan Feb Mar Apr May Jun Jul Project 1 6 7 3 0 3 4 3 Project 2 5 4 5 7 12 5 1 Project 3 8 7 1 9 2 14 1
Thanks for your help
From: "Sunmaia" <[EMAIL PROTECTED]>
To: "shaun thornburgh" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>
Subject: RE: A query that groups information by month
Date: Thu, 10 Jun 2004 11:18:38 +0100
select month(booking_date) bookings_month, count(bookings) as bookings GROUP BY month(booking_date)
Peter
> -----Original Message----- > From: shaun thornburgh [mailto:[EMAIL PROTECTED] > Sent: 10 June 2004 11:12 > To: [EMAIL PROTECTED] > Subject: A query that groups information by month > > > Hi, > > I have a table that holds information on bookings for a > scheduling system. > Is it possible to produce a report that lists total bookings data > by month > with one query > > i.e. > > Jan Feb Mar Apr May Jun Jul > 6 7 3 9 2 4 3 > > Thanks for you help > > _________________________________________________________________ > Stay in touch with absent friends - get MSN Messenger > http://www.msn.co.uk/messenger > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > Email has been scanned for viruses and SPAM by Trader Mailmanager > www.trader.uk.com > > > >
_________________________________________________________________
Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]