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]