[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]

Reply via email to