UFN_CONSTITUENT_GETMEMBERSHIPPROGRAMS

create function dbo.UFN_CONSTITUENT_GETMEMBERSHIPPROGRAMS
(
    @CONSTITUENTID uniqueidentifier
)
returns table

as

    return
    (
        select dbo.MEMBERSHIP.MEMBERSHIPPROGRAMID
        from dbo.MEMBERSHIP
        join dbo.MEMBER
            on dbo.MEMBER.CONSTITUENTID = @CONSTITUENTID
            and dbo.MEMBER.MEMBERSHIPID = dbo.MEMBERSHIP.ID
    )