=== modified file 'resources/sql/div.sql' --- resources/sql/div.sql 2012-11-20 21:04:24 +0000 +++ resources/sql/div.sql 2012-12-07 14:13:31 +0000 @@ -70,7 +70,7 @@ where ous.level=5 order by province, county, district, ou.name; --- Compare user roles +-- Compare user roles (lists what is in the first role but not in the second) select authority from userroleauthorities where userroleid=33706 and authority not in (select authority from userroleauthorities where userroleid=21504);