SELECT T1.Delegate ,  T2.Party FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID
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
select t1 . delegate , t2 . party from election as t1 join party as t2 on t1 . party = t2 . party_id
For each delegate , find the names of the party they are part of .