CREATE TABLE election (Delegate VARCHAR2, Party VARCHAR2)
CREATE TABLE party (Party VARCHAR2, Party_ID VARCHAR2)

Show the delegates and the names of the party they belong to.
SELECT T1.Delegate, T2.Party FROM election AS T1 JOIN party AS T2 ON T1.Party = T2.Party_ID
SELECT "T1"."Delegate", "T2"."Party" FROM "election" "T1" JOIN "party" "T2" ON "T1"."Party" = "T2"."Party_ID"