Index: openacs-4/packages/chat/www/room-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/www/room-oracle.xql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/chat/www/room-oracle.xql	30 Mar 2006 09:15:12 -0000	1.1.2.1
+++ openacs-4/packages/chat/www/room-oracle.xql	10 Apr 2006 11:41:39 -0000	1.1.2.2
@@ -26,7 +26,7 @@
   <querytext>
    select m.party_id, p.last_name || ', ' || p.first_names as name, pa.email
     from acs_object_party_privilege_map m, persons p, parties pa
-    where m.party_id = p.person and m.object_id = :room_id
+    where m.party_id = p.person_id and m.object_id = :room_id
     and m.privilege = 'chat_ban' and p.person_id = pa.party_id
     order by p.last_name, p.first_names
   </querytext>