On Wed, 15 Nov 2006, r937 wrote: > > 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
Aah, I'm with you. Thanks for the clarification Rudy, much appreciated. I'll remember that one for future use :) ____ 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.
