If I understand right, you're saying that using an aggregating function on
a field you haven't included in the GROUP BY clause is illegal in "real"
databases, and unpredictable in MySQL (like most things in MySQL ;) )?
no, it isn't "using an aggregating function on" that is the problem
you ~can~ do this in any database --
select a, b, c, count(d) ... group by a, b, c
see, you are aggregating d but it's not in the GROUP BY
what's not legal is having a non-aggregate in the SELECT that isn't in the
GROUP BY --
select a, b, c, count(*) ... group by a, b
see, c is in the SELECT but it is "hidden" (missing) from the GROUP BY
____ The WDVL Discussion List from WDVL.COM ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
