Hi Shaun!
I beg you pardon, my last message was incomplete! I will quote the
last lines from my previous post:
---8<----- Cut here -------8<-------
>
> - Thanks to the LIMIT clause, we get only the first result, which by
> the way is one of the projects with the most assigned tasks. If you want
to
> further select which one of the projects with the most assigned tasks you
> want, you must order by another column, like date (or filter out the
> projects in the WHERE clause).
>
> Given said that,
>
> Cheers,
> Jose Miguel.
---8<----- Cut here -------8<-------
It was my intention to finish the message as:
"Given said that, if you want more information on how this select
works, do not hesitate to ask. ;-)"
Again, I apologize for the confusion.
Cheers,
Jose Miguel.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]