select s.LastSurname, s.FirstName, 'Program' as [Type] ,ds.CodeValue as Code, ds.ShortDescription as Description from edfi.StudentSpecialEducationProgramAssociationSpecialEducationProgramService spa left join edfi.Descriptor ds on ds.DescriptorId=spa.SpecialEducationProgramServiceDescriptorId left join edfi.Student s on s.StudentUSI=spa.StudentUSI union select s.LastSurname, s.FirstName, 'Service' as [Type] ,ds.CodeValue as Code, ds.ShortDescription as Description from mi.StudentSpecialEducationProgramAssociationProgramSupport spa left join edfi.Descriptor ds on ds.DescriptorId=spa.ProgramSupportDescriptorId left join edfi.Student s on s.StudentUSI=spa.StudentUSI order by LastSurname, FirstName, [Type]