SELECT A.*,B.chrDesignationName,C.type_name,E.salutation_name FROM faculty A LEFT JOIN designation B ON A.intDesignationID=B.intAutoNo LEFT JOIN faculty_type C ON A.faculty_type_id=C.type_id LEFT JOIN salutation E ON A.intSalutaionID=E.salutation_id WHERE A.intDepartmentId='40' AND UPPER(A.faculty_url_param)='SHEREEMA'
