Index: openacs-4/contrib/packages/project-manager/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/index-postgresql.xql,v
diff -u -r1.12 -r1.12.2.1
--- openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	12 Mar 2004 13:44:44 -0000	1.12
+++ openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	2 Jul 2004 23:13:49 -0000	1.12.2.1
@@ -27,6 +27,8 @@
                 end as customer_name,
         o.organization_id as customer_id
         FROM pm_projectsx p 
+             LEFT JOIN pm_project_assignment pa 
+                ON p.item_id = pa.project_id
              LEFT JOIN organizations o ON p.customer_id =
                 o.organization_id 
              LEFT JOIN (