CREATE TABLE party (party_name VARCHAR, party_id VARCHAR)
CREATE TABLE Member (member_name VARCHAR, party_id VARCHAR)

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
SELECT "T1"."member_name", "T2"."party_name" FROM "Member" AS "T1" JOIN "party" AS "T2" ON "T1"."party_id" = "T2"."party_id"