TheselectIamdoingisthis:
SELECTDISTINCTdbo.Entity.ComercialName,dbo.ScheduleStatus.Description,dbo.ScheduleGoal.DescriptionASalias_DSG,dbo.ScheduleType.DescriptionASalias_DST,dbo.Entity.ID,dbo.Schedule.Notes,dbo.Schedule.DATEFROM(dbo.ScheduleRIGHTJOINdbo.ScheduleStatusONScheduleStatus.id=Schedule.ScheduleStatus)RIGHTJOINdbo.ScheduleGoalONSchedule.ScheduleGoal=ScheduleGoal.IdRIGHTJOINdbo.ScheduleTypeONSchedule.ScheduleType=ScheduleType.idRIGHTJOINdbo.EntityONSChedule.Entity=Entity.IdGROUPBYEntity.ComercialName,ScheduleStatus.Description,ScheduleGoal.Description,ScheduleType.Description,Entity.ID,Schedule.Notes,Schedule.DATE;TheresultIwantis:
