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 mi.InterventionExtension ie on ie.InterventionIdentificationCode=i.InterventionIdentificationCode left join edfi.Descriptor ict on ict.DescriptorId=i.InterventionClassDescriptorId left join edfi.EducationOrganization eo on eo.EducationOrganizationId=i.EducationOrganizationId left join edfi.StudentInterventionAssociation sia on sia.InterventionIdentificationCode=i.InterventionIdentificationCode left join mi.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.InterventionStaff ist on ist.InterventionIdentificationCode=i.InterventionIdentificationCode and ist.EducationOrganizationId=i.EducationOrganizationId left join edfi.Staff st on st.StaffUSI=ist.StaffUSI order by s.LastSurname,s.FirstName