son p
INNER JOIN [identity] i ON i.identityID = p.currentidentityID
LEFT OUTER JOIN contact c1 ON c1.person... FT OUTER JOIN [identity] i2 ON i2.identityID = p2.currentIdentityID
LEFT OUTER JOIN contact c2 ON c2.person... teacherpersonID
LEFT OUTER JOIN [identity] i4 WITH (NOLOCK) ON i4.identityID = p4.currentidentityID
</code>
ear AND SY.active = 'true'
JOIN [IDENTITY] I ON P.currentIdentityID = I.identityID
),
RP AS (
SELECT RP.*,R... N EA.schoolID = S.schoolID
JOIN [IDENTITY] I ON P.currentIdentityID = I.identityID
LEFT JOIN POSIdentificat