Show member names with a registered branch?
SELECT name FROM member WHERE member_id IN  ( SELECT member_id FROM membership_register_branch ) 
show member names = SELECT name; with a registered branch = WHERE member_id IN (SELECT member_id FROM membership_register_branch);