On Mon, Mar 6, 2017 at 8:25 AM, Mark Alexander <[email protected]> wrote:
> > Pretty close! Just some misplaced parens: > > SELECT > monthname(datetime), > SUM( IF(type = 'issue', 1, 0 )) as issues, > SUM( IF(type = 'renew', 1, 0 )) as renewals, > SUM( IF(type = 'return', 1, 0 )) as returns > > Thanks Mark! I've definitely done worse on a first draft ;-) _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
