On Sun, Jun 1, 2008 at 4:39 AM, Russell Keith-Magee
<[EMAIL PROTECTED]> wrote:
> SELECT author.id, author.name, author.age, COUNT(book.id)
>  FROM author INNER JOIN book ON author.id=book.author_id
>  GROUP BY author.id, author.name, author.age;
>
> is the same as
>
> SELECT author.id, author.name, author.age, COUNT(book.id)
>  FROM author INNER JOIN book ON author.id=book.author_id
>  GROUP BY author.id;
>

This is a MySQL only thing:

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

Craig

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Django developers" group.
To post to this group, send email to django-developers@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-developers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to