Index: openacs-4/packages/acs-subsite/www/admin/group-types/one-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/group-types/one-oracle.xql,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/acs-subsite/www/admin/group-types/one-oracle.xql 15 May 2001 16:59:00 -0000 1.1 +++ openacs-4/packages/acs-subsite/www/admin/group-types/one-oracle.xql 13 Mar 2002 22:50:53 -0000 1.2 @@ -19,7 +19,7 @@ - select my_view.group_name, my_view.group_id, rownum as num + select my_view.group_name, my_view.group_id from (select /*+ ORDERED */ DISTINCT g.group_name, g.group_id from acs_objects o, groups g, application_group_element_map app_group,