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

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" AS "T1" JOIN "party" AS "T2" ON "T1"."Party" = "T2"."Party_ID"