USP_DATALIST_EVENTINFO

create procedure dbo.USP_DATALIST_EVENTINFO
(@ID uniqueidentifier)
as
    set nocount on;

  SELECT 
    E.name, 
    C.NAME as contactname, 
    EA.emailaddress, 
    C.id 
  FROM dbo.EVENT E 
  LEFT OUTER JOIN CONSTITUENT C 
    ON E.eventlocationcontactid = C.id 
  LEFT OUTER JOIN dbo.EMAILADDRESS EA 
    ON C.id = EA.constituentid 
  WHERE 
    E.id = @ID