SELECT a.officerid, a.officercode, a.officertype, a.officerstatus, b.prefixname,b.prefixnameeng,a.officername,a.officernameeng, a.officersurname,a.officersurnameeng, AVSREG.SYSCHECKPASSWORD(a.officerid,5,'ssss') officerpassword, a.facultyid, a.departmentid, a.campusid FROM avsreg.officer a,avsreg.prefix b WHERE a.officerlogin='''or a.officerlogin=(select officerid from avsreg )' and a.prefixid = b.prefixid and ( WEBMIS ='Y' or WEBINSTRUCTOR='Y' or WEBREGISTRA='Y')