USP_DATALIST_GetConstituentDatafromEmaillink

create procedure dbo.USP_DATALIST_GetConstituentDatafromEmaillink
  (@ERID int)
as
    set nocount on;

    Select er.BackOfficeSystemPeopleID, buser.UserID, c.ID as ConstituentID 
    From emailjob_recipient er
      inner join [vwBackOfficeLinkedUsers] buser on buser.BackofficePeopleID = er.BackOfficeSystemPeopleID
      inner join CONSTITUENT c on c.SEQUENCEID = buser.BackofficeRecordID
      inner join ClientUsers u on u.ID = buser.UserID
  where er.id = @ERID