[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 and I can help you
figure out what we are missing.
You're missing an "OUTER" in the join on the query, his originally
request was to include "0"s for months with no bookings, e.g. Jan, Feb, Apr.
- Oliver
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]