UFN_NETCOMMUNITYEMAILJOBRECIPIENT_EMAIL

CREATE function dbo.UFN_NETCOMMUNITYEMAILJOBRECIPIENT_EMAIL()
returns table
as return 
   select
    BBNC.ID as ID,
    BBNC.BBNCMAPID as BBNCMAPID,
    BBNC.CONSTITUENTID as CONSTITUENTID,
    BBNC.EMAILBBNCMAPID as EMAILID,
    BBNC.EMAILTEMPLATEBBNCMAPID as EMAILTEMPLATEID,
    BBNC.EMAILNAME AS EMAILNAME,
    BBNC.EMAILSUBJECT AS EMAILSUBJECT,
    BBNC.SENTDATE AS SENTDATE,
      BBNC.BOUNCED AS BOUNCED,
    BBNC.BOUNCETEXT AS BOUNCETEXT,
    BBNC.OPENED AS OPENED,
    BBNC.UPDATEDATE AS UPDATEDATE,
    BBNC.EMAILADDRESS AS EMAILADDRESS,
    BBNC.CLICKEDTHROUGH AS CLICKEDTHROUGH,
    BBNC.DONATED AS DONATED,
    BBNC.URL AS URL,
    BBNC.ADDEDBYID AS ADDEDBYID,
      COALESCE(EM.AppealID, BBNC.APPEALID) AS APPEALID,
    COALESCE(EM.[Type], BBNC.EMAILTYPEID) AS EMAILTYPEID,
    BBNC.SPAMCOMPLAINT as SPAMCOMPLAINT,
    BBNC.OPTEDOUT as OPTEDOUT
   from
      dbo.NETCOMMUNITYEMAILJOBRECIPIENT BBNC
         left join dbo.EMAIL EM on EM.ID = BBNC.EMAILBBNCMAPID;