I need to return all the columns from the ProspectLead (pl) table which are already in the main select statement but i also need to retrieve the additional three columns from LeadfrontierData which are

lfd.PricePlan as Tariff, lfd.Price, Convert(varchar(10),lfd.ContractEndDate) as ContractEndDate

but my problem is LeadFrontierData could have more then 1 record linked to the same ID which is correct but when i display it i should only have one row for the ID 1