> >A subselect may help:
> >[...]
> >Don't know ATM if it can be done more easily, but a query like this
> >should probably work.
> >
> It can be done without a sub-query:
> [...]
>
> That *should* work, barring any typos or ommisions I may have made. I
> used LEFT JOIN because of personal prefere
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.
Frederic Wenzel wrote:
On Sun, 17 Oct 2004 19:36:34 +, shaun thornburgh
<[EMAIL PROTECTED]> wrote:
A Project will have 1 or more tasks assigned to it. Using the following
query, how can I modify it so that I can find out the largest number of
tasks assigned to a group of projects.
SELECT P.*
Hi Shaun!
> A Project will have 1 or more tasks assigned to it. Using the
> following
> query, how can I modify it so that I can find out the largest
> number of
> tasks assigned to a group of projects.
>
> SELECT P.*, T.*
> FROM Projects P, Tasks T
> WHERE P.Project_ID = T.Project_ID
> AND P
On Sun, 17 Oct 2004 19:36:34 +, shaun thornburgh
<[EMAIL PROTECTED]> wrote:
> A Project will have 1 or more tasks assigned to it. Using the following
> query, how can I modify it so that I can find out the largest number of
> tasks assigned to a group of projects.
>
> SELECT P.*, T.*
> FROM Pr
Hi,
Tihs looks to me as too few information.
What is in your tables (the information)?
What does the query return (a empty set)? Maybe 'cause in your where clause
where you have Project_ID >2 you should have Project_ID=2? Or you have
several projects with ID>2 and you want tasks for all of
