-- Database schema
| region : Region_ID [ INT ] primary_key , Region_name [ TEXT ] , Date [ TEXT ] , Label [ TEXT ] , Format [ TEXT ] , Catalogue [ TEXT ] | party : Party_ID [ INT ] primary_key , Minister [ TEXT ] , Took_office [ TEXT ] , Left_office [ TEXT ] , Region_ID [ INT ] party.Region_ID = region.Region_ID , Party_name [ TEXT ] | member : Member_ID [ INT ] primary_key , Member_Name [ TEXT ] , Party_ID [ TEXT ] member.Party_ID = party.Party_ID , In_office [ TEXT ] | party_events : Event_ID [ INT ] primary_key , Event_Name [ TEXT ] , Party_ID [ INT ] party_events.Party_ID = party.Party_ID , Member_in_charge_ID [ INT ] party_events.Member_in_charge_ID = member.Member_ID |
-- -- 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;