CREATE TABLE party (party_name VARCHAR2, region_id VARCHAR2)
CREATE TABLE region (region_name VARCHAR2, region_id VARCHAR2)

Show all party names and their region names.
SELECT T1.party_name, T2.region_name FROM party AS T1 JOIN region AS T2 ON T1.region_id = T2.region_id
SELECT "T1"."party_name", "T2"."region_name" FROM "party" "T1" JOIN "region" "T2" ON "T1"."region_id" = "T2"."region_id"