Show member names without any registered branch?
SELECT name FROM member WHERE member_id NOT IN  ( SELECT member_id FROM membership_register_branch ) 
member names without any registered branch refers to members who are not listed in the membership_register_branch table;