Fulltext results:
- Superset @campus:data:query
- '+a.apt END,'') END AS StudentPrimaryContactStreetAddress, a.city AS StudentPrimaryContactCity, a.state AS ... 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