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=3D'8' AND
events.eventReview!=3D'' AND
events.modlast > 1146470445 AND
events.eventID =3D attribute_master.id AND
attribute_master.tableis =3D '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?

--
Wellington

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3...ie.nctu.edu.tw

At 18:28 -0400 5/11/06, Fan, Wellington wrote:
It's a MySQL extension to GROUP BY:

http://dev.mysql.com/doc/refman/5.0/...en-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/mysql?unsub=m...ie.nctu.edu.tw