Hi,

I have two tables in my database. One that holds information on bookings on varous projects for a scheduling system, and the other holds project informtaion.

Is it possible to produce a report that lists total bookings by project a month with one query i.e.

            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

_________________________________________________________________
Express yourself with cool new emoticons http://www.msn.co.uk/specials/myemo


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to