kinderdesign (3/15/2012)

---

Here's the union on how these particular three are related:

SELECT FacilitiesList.Name

FROM FacilitiesList INNER JOIN

InspectionsList ON InspectionsList.ParentUNID = FacilitiesList.UNID RIGHT OUTER JOIN

ViolationList ON InspectionsList.UNID = ViolationList.UNID