CREATE TABLE membership_register_branch (name VARCHAR, member_id VARCHAR)
CREATE TABLE member (name VARCHAR, member_id VARCHAR)

Show member names without any registered branch.
SELECT name FROM member WHERE NOT member_id IN (SELECT member_id FROM membership_register_branch)
SELECT "name" FROM "member" WHERE NOT "member_id" IN (SELECT "member_id" FROM "membership_register_branch")