UFN_REGISTRANT_RESTRICTIONOPTIONS

            CREATE function dbo.UFN_REGISTRANT_RESTRICTIONOPTIONS
            (
                @REGISTRANTID uniqueidentifier
            )
            returns table
            as 
                return
                (
                    select
                        REGISTRANTRESTRICTIONOPTION.ID [ID],
                        EVENTRESTRICTIONTYPE.ID [EVENTRESTRICTIONTYPEID],
                        EVENTRESTRICTIONOPTION.ID [EVENTRESTRICTIONOPTIONID],
                        EVENTRESTRICTIONTYPE.NAME [EVENTRESTRICTIONTYPENAME],
                        EVENTRESTRICTIONOPTION.NAME [EVENTRESTRICTIONOPTIONNAME]
                    from dbo.REGISTRANTRESTRICTIONOPTION
                    inner join dbo.EVENTRESTRICTIONOPTION
                        on EVENTRESTRICTIONOPTION.ID = REGISTRANTRESTRICTIONOPTION.EVENTRESTRICTIONOPTIONID
                    inner join dbo.EVENTRESTRICTIONTYPE
                        on EVENTRESTRICTIONTYPE.ID = EVENTRESTRICTIONOPTION.EVENTRESTRICTIONTYPEID
                    where REGISTRANTID = @REGISTRANTID
                )