Jerry Schwartz wrote:
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?
Perfectly legal, will not get changed. :)
Cheers,
Mark
--
Mark Leith, Support Engineer
MySQL AB, Worcester, England, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
