UFN_SITEID_MAPFROM_FUNDRAISINGGROUPID

      CREATE FUNCTION DBO.UFN_SITEID_MAPFROM_FUNDRAISINGGROUPID  
           (  
                @FUNDRAISINGGROUPID UNIQUEIDENTIFIER  
           )   
           RETURNS TABLE
           AS  
            RETURN
                (
          SELECT ES.SITEID
          FROM TEAMFUNDRAISINGTEAM TFT
          LEFT JOIN TEAMEXTENSION TE ON TE.TEAMFUNDRAISINGTEAMID=TFT.ID
          LEFT JOIN EVENTSITE ES ON ES.EVENTID = TE.EVENTID
          WHERE TFT.ID = @FUNDRAISINGGROUPID
                )