-- Database schema
| county : County_Id [ INT ] primary_key , County_name [ TEXT ] , Population [ INT ] , Zip_code [ TEXT ] | party : Party_ID [ INT ] primary_key , Year [ INT ] , Party [ TEXT ] , Governor [ TEXT ] , Lieutenant_Governor [ TEXT ] , Comptroller [ TEXT ] , Attorney_General [ TEXT ] , US_Senate [ TEXT ] | election : Election_ID [ INT ] primary_key , Counties_Represented [ TEXT ] , District [ INT ] election.District = county.County_Id , Delegate [ TEXT ] , Party [ INT ] election.Party = party.Party_ID , First_Elected [ INT ] , Committee [ TEXT ] |
-- -- 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;