postgresql 7.3 SELECT t.item_id, t.revision_id, i.live_revision, t.title as task_title, t.description || ' -- ' || p.first_names || ' ' || p.last_name as description, t.mime_type, to_char(t.end_date,'MM/DD/YYYY') as end_date, t.percent_complete, t.estimated_hours_work_min, t.estimated_hours_work_max, t.actual_hours_worked FROM pm_tasks_revisionsx t, cr_items i, persons p WHERE t.item_id = :task_id and t.item_id = i.item_id and t.creation_user = p.person_id [template::list::orderby_clause -name revisions -orderby]