spChapterMemberRoles

            CREATE Procedure [dbo].[spChapterMemberRoles]
            @ClientsID as int,
            @MemberType as int

            as

            SELECT chpt.Name as ChapterName, chpt.MemberEmailListID, chr.ChapterID, cr.REQueryID, cr.BBSystem, cr.REConstituentsOnly 
            FROM ChapterRoles as chr 
            inner join ClientRoles as cr ON chr.ClientRolesID = cr.[ID]
            inner join Chapters as chpt ON chpt.ID = chr.ChapterID
            WHERE chr.Type = @MemberType AND cr.ClientsID = @ClientsID