has someone tried to create a list of all dotlrn administrators before? While classes have 4 different relations subgroups have only two (admin, member). I need to create a mailing list of all administrators.
Greetings, Nima
select object_id_two from users u, acs_rels a, dotlrn_admin_rels d where a.rel_id=d.rel_id and object_id_two=u.user_id;
You'll want to get unique rows so you only email each admin once.