[wellylug] sql query so slooooooow

Joe Mahoney joe at cheerschopper.com
Tue Nov 20 11:23:34 NZDT 2007


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

Joe Mahoney
http://blog.cheerschopper.com




More information about the wellylug mailing list