USP_DATALIST_ADDRESSBOOKFAFSIMPLE

CREATE procedure dbo.USP_DATALIST_ADDRESSBOOKFAFSIMPLE(
@ADDRESSBOOKFAFID uniqueidentifier = null,
@CONSTITUENTID uniqueidentifier = null,
@EVENTID uniqueidentifier
)
as
      set nocount on;
-- get all constituent data for sending email

  SELECT 
    A.ID,
            A.FIRSTNAME,
            A.LASTNAME,
            A.EMAILADDRESS,
            A.CONSTITUENTID,
            C.ISGROUP,
            R.ID AS REGISTRANTID,
            A.MiddleNAME
  FROM dbo.ADDRESSBOOKFAF A
  LEFT OUTER JOIN dbo.CONSTITUENT C
  ON A.CONSTITUENTID = C.ID AND C.ISGROUP = 1
  LEFT OUTER JOIN dbo.REGISTRANT R
  ON A.CONSTITUENTID = R.CONSTITUENTID AND R.EVENTID = @EVENTID
  WHERE A.ID = @ADDRESSBOOKFAFID

  UNION 

  SELECT 
    A.ID,
            A.FIRSTNAME,
            A.LASTNAME,
            A.EMAILADDRESS,
            A.CONSTITUENTID,
            C.ISGROUP,
            R.ID AS REGISTRANTID,
            A.MiddleNAME
  FROM dbo.ADDRESSBOOKFAF A
  LEFT OUTER JOIN dbo.CONSTITUENT C
  ON A.CONSTITUENTID = C.ID AND C.ISGROUP = 1
  LEFT OUTER JOIN dbo.REGISTRANT R
  ON A.CONSTITUENTID = R.CONSTITUENTID AND R.EVENTID = @EVENTID
  WHERE A.CONSTITUENTID = @CONSTITUENTID