CREATE TABLE region (region_name VARCHAR(255), region_id VARCHAR(255)); CREATE TABLE party (party_name VARCHAR(255), region_id VARCHAR(255))
Show all party names and their region names.
    
SQL: SELECT T1.party_name, T2.region_name FROM party AS T1 JOIN region AS T2 ON T1.region_id = T2.region_id