select s.LastSurname,s.FirstName,rt.Description as Relation,p.LastSurname as ParentLast, p.FirstName as ParentFirst
from edfi.Student s
left join edfi.StudentParentAssociation spa on spa.StudentUSI=s.StudentUSI
left join edfi.Parent p on p.ParentUSI=spa.ParentUSI
left join edfi.RelationType rt on rt.RelationTypeId=spa.RelationTypeId
order by s.LastSurname,s.FirstName