[wellylug] sql query so slooooooow

[E Chalaron]

Joe Mahoney wrote:
> yeah, what everyone else said while I was busy formatting my reply.
> You need to join the two tables using something like this (assuming
> tasks belong to projects):
>
> select task.name, project.name, task.date_closed
> from task inner join project on task.project_id = project.id
> order by task.name asc, project.name asc, task.date_closed asc
>   
Thanks all for the reply...
I understand better now.
Just to make sure : when you write "tasks belong to projects", in my 
case task and project are 2 different tables from the same database.
Cheers
E