select s.StudentUniqueId,s.LastSurname,s.FirstName,'No Education Organization Association for student' as Message
from edfi.Student s
left join edfi.StudentSchoolAssociation ssa on ssa.StudentUSI=s.StudentUSI
left join edfi.StudentEducationOrganizationAssociation seoa on seoa.StudentUSI=s.StudentUSI
where seoa.StudentUSI is null and ssa.StudentUSI is not null
order by s.LastSurname,s.FirstName