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

[Fan, Wellington]

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?

--
Wellington

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