What are the names of members and their corresponding parties?
select t1.member_name, t2.party_name from member as t1 join party as t2 on t1.party_id = t2.party_id