select sect.sectname as section, role.roledescr, pers.perslastname as lastname, pers.persfirstname as firstname,
pers.persuhuuid as uhnumber, pers.persitsusername as username, pers.persemail as email
from personnel pers, persposition ppos, section sect, role
where pers.persid = ppos.persid
and ppos.pposstatus = 'A'
and pers.roleid = role.roleid
and ppos.sectid = sect.sectid
union all
-- all students
select sect.sectname as section, role.roledescr, std.stdlastname as lastname, std.stdfirstname as firstname,
pers.persuhuuid as uhnumber, pers.persitsusername as username, pers.persemail as email
from personnel pers, persposition ppos, section sect, role,
seceadm.student@secedb_link.db.uh std,
seceadm.placement@secedb_link.db.uh plc
where pers.roleid = 9
and pers.roleid = role.roleid
and pers.persid = ppos.persid
and pers.persuhuuid = std.stduhuuid
and std.stdid = plc.stdid
and plc.plcstatus = 'A'
and plc.plcid = ppos.empid
and ppos.sectid = sect.sectid
order by section, lastname, firstname;
General
Content
Integrations