select distinct
RTRIM(REG_STAFF.DISTRICT) as 'DistrictID', RTRIM(BUILDING) as 'CampusID', RTRIM(SCHD_MS_SESSION.PRIMARY_STAFF_ID) as 'SPID',
RTRIM(FIRST_NAME) as 'FirstName', RTRIM(MIDDLE_NAME) as 'MiddleName', RTRIM(LAST_NAME) as 'LastName', RTRIM(email) as 'Email'

from  SCHD_MS_SESSION
left join SCHD_MS on SCHD_MS.SECTION_KEY= SCHD_MS_SESSION.SECTION_KEY 
left join REG_STAFF on REG_STAFF.STAFF_ID= SCHD_MS_SESSION.PRIMARY_STAFF_ID

 where SCHOOL_YEAR =(select SCHOOL_YEAR from REG_DISTRICT where DISTRICT='XXXXXX') 
and email is not null