Index: openacs-4/contrib/packages/project-manager/www/dependency-add-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/dependency-add-edit-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/packages/project-manager/www/dependency-add-edit-postgresql.xql	18 Sep 2003 23:33:54 -0000	1.2
+++ openacs-4/contrib/packages/project-manager/www/dependency-add-edit-postgresql.xql	10 Oct 2003 22:51:04 -0000	1.3
@@ -29,9 +29,10 @@
         t.name,
         t.parent_id,
 	to_char(t.end_date,'Mon DD ''YY') as end_date,
-        t.percent_complete
+        t.percent_complete,
+        d.parent_task_id
 	FROM
-	pm_tasks_revisionsx t, cr_items i
+	pm_tasks_revisionsx t, cr_items i LEFT JOIN pm_task_dependency d ON i.item_id = d.task_id
         WHERE
         t.revision_id in ([join $task_revisions ", "]) and
         i.item_id = t.item_id