[snip]It's a shorthand way to say that I wanted to group on the first two columns of my select statement.
Here's a quote from the manual: http://dev.mysql.com/doc/mysql/en/SELECT.html
Columns selected for output can be referred to in ORDER BY and GROUP BY clauses using column names, column aliases, or column positions. Column positions are integers and begin with 1: mysql> SELECT college, region, seed FROM tournament -> ORDER BY region, seed; mysql> SELECT college, region AS r, seed AS s FROM tournament -> ORDER BY r, s; mysql> SELECT college, region, seed FROM tournament -> ORDER BY 2, 3; <<<
Since he had 3 columns in his SELECT clause but only the third one had an aggregate function applied to it, I "grouped" on the other two. I could have written it the long way as:
GROUP BY _objectives.id, _objectives.name
Make sense?
Yes, cheers. I shall make sure I avoid doing this, for readability's sake:-) Looks like a crunch / packing program has been set loose on it, like when wrote stuff on BBC's etc and crunched the code so it would fit:-)
But I get it.
I just love mySQL, it has removed so many layers of complication from my coding life.... and left only 1 layer of not too much complicatedness:-)
Site below is powered by mySQL.
M. -- Mark Worsdall http://www.vote4president.net
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
