#disciplineDesc#
SELECT a.MBMID, FNAME, LNAME, a.TITLE, a.EMAIL, c.DEPTNAME, a.photo
FROM MBM.MBMPERSON a left join MBM.PERSONDEPT b
on a.mbmid = b.mbmid
left join MBM.DEPARTMENT c
on b.DEPTID = c.DEPTID
WHERE (Lower(a.MBMID) = Lower())
| #list_person.FNAME#, #list_person.LNAME# |
| #list_person.TITLE# |
| #list_person.EMAIL# |
| |
|
