c2 ON c2.personID = p2.personID
LEFT OUTER JOIN address a ON a.addressID =
(SELECT TOP 1 x.addressID FRO... endDate IS NULL OR l.endDate >= GETDATE())
JOIN address x ON x.addressID = l.addressID
WHERE m.personID... 1 THEN 0 ELSE 1 END,l.secondary)
--************** Address CASE statement for PO box. This is the library extract therefore the mailing address is preferred *******
LEFT OUTER JOIN [section]