List member names and their party names.
select t1.member_name, t2.party_name from member as t1 join party as t2 on t1.party_id = t2.party_id