postgresql7.2 SELECT i.item_id, repeat(:indent_pattern, (tree_level(i.tree_sortkey) - 2)* :indent_factor) as indent, t.folder_id, t.content_type, p.project_name, p.project_folder_id, p.project_code, to_char(p.planned_start_date, 'YYYY MM DD') as planned_start_date, to_char(p.planned_end_date, 'YYYY MM DD') as planned_end_date, p.ongoing_p FROM cr_items i, cr_folder_type_map t, pm_projectsx p WHERE t.content_type = 'pm_project' AND i.item_id = t.folder_id AND p.project_folder_id = t.folder_id ORDER BY i.tree_sortkey