SELECT name FROM member WHERE member_id NOT IN (SELECT member_id FROM membership_register_branch)
Show member names without any registered branch.
SELECT name FROM member WHERE member_id NOT IN ( SELECT member_id FROM membership_register_branch )
select name from member where member_id not in ( select member_id from membership_register_branch )
Show member names without any registered branch .