For each delegate, find the names of the party they are part of.
SELECT T1.Delegate ,  T2.Party FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID
names of the party they are part of refers to T2.Party; for each delegate refers to SELECT T1.Delegate; JOIN is used to combine rows from two or more tables based on a related column between them.