Loma Linda University

Enrollment Information
Call us at: 909-558-1000

Faculty Directory

Faculty Listing A-Z


| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |

SELECT DISTINCT Common_Tables.dbo.FACULTY_MIN.FIRST_NAME first_name, Common_Tables.dbo.FACULTY_MIN.MIDDLE_NAME middle_name, Common_Tables.dbo.FACULTY_MIN.LAST_NAME last_name, EID eid, Common_Tables.dbo.EDMS.LDAP_ID ldap_id FROM Common_Tables.dbo.EDMS INNER JOIN Common_Tables.dbo.FACULTY_MIN ON Common_Tables.dbo.FACULTY_MIN.ID_KEY = Common_Tables.dbo.EDMS.BANNER_ID INNER JOIN Common_Tables.dbo.FACULTY_APPOINTMENTS_MIN ON Common_Tables.dbo.FACULTY_APPOINTMENTS_MIN.ID_KEY = Common_Tables.dbo.EDMS.BANNER_ID WHERE SUBSTRING(Common_Tables.dbo.FACULTY_MIN.LAST_NAME, 1, 1) = 'S' AND Common_Tables.dbo.FACULTY_MIN.ID_KEY <> 8923231 AND Common_Tables.dbo.FACULTY_APPOINTMENTS_MIN.STATUS_CATEGORY_CODE <> 'CT' ORDER BY Common_Tables.dbo.FACULTY_MIN.LAST_NAME, Common_Tables.dbo.FACULTY_MIN.FIRST_NAME [nativecode=4413 - Could not use view or function 'Common_Tables.dbo.FACULTY_MIN' because of binding errors.]