select eo.NameOfInstitution,s.LastSurname,s.FirstName
,ie.InterventionName
,sia.CreateDate,siae.Goal,i.BeginDate,siae.ProspectiveEndDate
,st.LastSurname as TeacherLast, st.FirstName as TeacherFirst
,ict.Description as InterventionClass,i.EndDate,ie.InterventionContactName,ie.InterventionContactElectronicMailAddress,ie.InterventionDescription
from edfi.Intervention i
left join extension.InterventionExtension ie on ie.InterventionIdentificationCode=i.InterventionIdentificationCode
left join edfi.InterventionClassType ict on ict.InterventionClassTypeId=i.InterventionClassTypeId
left join edfi.EducationOrganization eo on eo.EducationOrganizationId=i.EducationOrganizationId
left join edfi.StudentInterventionAssociation sia on sia.InterventionIdentificationCode=i.InterventionIdentificationCode
left join extension.StudentInterventionAssociationExtension siae on siae.InterventionIdentificationCode=i.InterventionIdentificationCode and siae.StudentUSI=sia.StudentUSI
left join edfi.Student s on s.StudentUSI=sia.StudentUSI
left join edfi.Staff st on st.StaffUSI=sia.StaffUSI
order by s.LastSurname,s.FirstName