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