Fulltext results:
- Superset @campus:data:query
- c2 ON c2.personID = p2.personID LEFT OUTER JOIN address a ON a.addressID = (SELECT TOP 1 x.addressID FROM householdMember m JOIN householdLocation l ON l.householdID = m.hous... endDate IS NULL OR l.endDate >= GETDATE()) JOIN address x ON x.addressID = l.addressID WHERE m.personID