[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