UFN_TEAMFUNDRAISINGTEAMGROUP_GETTEAMS

            create function dbo.UFN_TEAMFUNDRAISINGTEAMGROUP_GETTEAMS
            (
                @ID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    TEAMFUNDRAISINGTEAM.APPEALID,
                    EVENT.ID [EVENTID],
                    TEAMFUNDRAISINGTEAM.ID [TEAMFUNDRAISINGTEAMID],
                    TEAMFUNDRAISINGTEAM.GOAL,
                    APPEAL.STARTDATE [APPEALSTARTDATE]
                from
                    dbo.TEAMFUNDRAISINGTEAM
                    left join dbo.EVENT on TEAMFUNDRAISINGTEAM.APPEALID = EVENT.APPEALID
                    left join dbo.APPEAL on TEAMFUNDRAISINGTEAM.APPEALID = APPEAL.ID
                where
                    TEAMFUNDRAISINGTEAM.TEAMFUNDRAISINGTEAMGROUPID = @ID
            )