I know that you can alias a function result as easily as anything else, but
I've run into a problem with an application I inherited. For reasons too
murky to go into, I would like to refer to the result of a group function as
the name of the argument of the function. Here's an example of what I mean:
SELECT book_author, GROUP_CONCAT(book_title) AS book_title GROUP BY
book_author WHERE book_title LIKE "<something>";
This actually seems to work, but it makes me ill to look at it. Is this
legal, or have I found a loophole that might be closed in the future?
I'm using server version 4.1.21-standard.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
