Dude! You just confused me with YOUR QUESTION under MY SUBJECT LINE :) :) :)
You have to change a Subject and send it again. Or we will not know to whom is sent. :) -afan > Hello all, > > I just inherited an application that has 2 tables under consideration, > "events" and "attribute_master". They are linked on (events.eventID = > attribute_master.id AND attribute_master.tableis = 'events'). In other > words, attribute_master.id is kinda like a foreign key to events.eventID, > but only where attribute_master.tableis = 'events'. > > I have ommited some columns from 'events' that I am fairly certain are NOT > germane to my question: > > CREATE TABLE attribute_master ( > tableis varchar(128) NOT NULL default '', > id int(12) NOT NULL default '0', > attributeID int(8) NOT NULL default '0', > PRIMARY KEY (tableis,id,attributeID) > ) TYPE=MyISAM; > > CREATE TABLE events ( > eventID mediumint(9) NOT NULL auto_increment, > eventReview text NOT NULL, > status tinyint(1) NOT NULL default '0', > modlast int(8) NOT NULL default '0', > PRIMARY KEY (eventID) > ) TYPE=MyISAM > > > #### Now, an intersting 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 > > So here's my question(s): Given this query, how can on GROUP BY operate on > a column that doesn't appear in the SELECT list? Secondly, 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
