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
delegates = T1.Delegate; names of the party they belong to = T2.Party; JOIN is used to combine rows from two or more tables based on a related column between them;