Ionel,
> Is there a requirement of a minimal MySQL version for it to work ?
There shouldn't be a problem. SUBDATE and INNER JOIN have been in since at
least 3.23, and these are the only ones that may be a problem. Try running it
against your database and tell me what error messages you get!
On
OMG Steve !
Thank you. Surely I know the SQL language but I won't be able to pull this one.
Is there a requirement of a minimal mysql version for it to work ?
Thanks again,
Ionel
On 02/10/2011 03:50 PM, Steve Durbin wrote:
Ionel,
This huge bit of SQL (for MySQL) will give you what you want.
Ionel,
This huge bit of SQL (for MySQL) will give you what you want. There's no
'stats' way of doing it I'm aware of. Note that a ticket that was closed then
reopened will be counted twice. The result here was:
++-+
| Fix Band | Tickets |
+-