Re: GROUP BY *column* when *column* is NOT in SELECT list?

[Paul DuBois]

At 18:28 -0400 5/11/06, Fan, Wellington wrote:

Hello all,

I have inherited this query:

SELECT
        events.eventID AS id,
        attribute_master.attributeID AS attrib_id
FROM
        events,
        attribute_master
WHERE
        events.status='8' AND
        events.eventReview!='' AND
        events.modlast > 1146470445 AND
        events.eventID = attribute_master.id AND
        attribute_master.tableis = 'events'
GROUP BY
        attribute_master.id

I thought that every column listed in the SELECT clause would have to be in an aggregate function or mentioned in the GROUP BY...how am I wrong?

It's a MySQL extension to GROUP BY:

http://dev.mysql.com/doc/refman/5.0/en/group-by-hidden-fields.html

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]