Index: openacs-4/packages/acs-service-contract/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/index-postgresql.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/acs-service-contract/www/index-postgresql.xql	31 Jan 2002 03:04:32 -0000	1.1
+++ openacs-4/packages/acs-service-contract/www/index-postgresql.xql	22 Apr 2003 12:52:07 -0000	1.1.4.1
@@ -5,13 +5,17 @@
 
 <fullquery name="valid_installed_binding">      
       <querytext>
-        select 
-            contract_id,
-            impl_id,
+         select 
+            b.contract_id,
+            b.impl_id,
             acs_sc_contract__get_name(contract_id) as contract_name,
-            acs_sc_impl__get_name(impl_id) as impl_name
+            acs_sc_impl__get_name(b.impl_id) as impl_name,
+            impl.impl_owner_name
         from
-            acs_sc_bindings
+            acs_sc_bindings b, 
+            acs_sc_impls impl
+        where
+            impl.impl_id = b.impl_id
       </querytext>
 </fullquery>