Fulltext results:

Superset @campus:data:query

3 Hits, Last modified: 17 months ago

N g.householdID = m.householdID LEFT OUTER JOIN relatedPair r ON r.personID1 = m.personID AND r.personID2... 1 ELSE 0 END, m.startDate DESC) LEFT OUTER JOIN relatedPair r ON r.personID1 = p.personID AND r.personID2 = (SELECT TOP 1 x.personID2 FROM relatedPair x LEFT OUTER JOIN householdMember m ON m.ho

Wagner Portrait Group @campus:data:query

1 Hits, Last modified: 16 months ago

BY RP.personID2) AS guardianSeq FROM S LEFT JOIN RelatedPair RP ON RP.personID1 = S.personID AND RP.endDat