hone,'') AS StudentPrimaryContactPhoneNumber
FROM person p
INNER JOIN [identity] i ON i.identityID = p.cur... oldID IS NULL THEN 1 ELSE 0 END)
LEFT OUTER JOIN person p2 ON p2.personID = r.personID2
LEFT OUTER JOIN [... (NOLOCK) ON rm.roomID = se.roomID
LEFT OUTER JOIN person p4 WITH (NOLOCK) ON p4.personID = se.teacherperso
studentNumber,I.firstName,I.lastName,E.grade
FROM Person P
JOIN Enrollment E ON P.personID = E.personID AN... ata AS lunchPin
FROM EmploymentAssignment EA
JOIN Person P ON EA.personID = P.personID
JOIN School S ON EA