Show member names without any registered branch.
create table member (name varchar, member_id varchar, PRIMARY KEY (name)); create table membership_register_branch (name varchar, member_id varchar, PRIMARY KEY (name))
select name from member where not member_id in (select member_id from membership_register_branch)