select distinct [Table1].FirstID, [Table1].MyParameter1, [Table1].MyParameter2,
   (select top  1  [Table3].[Name] from [Table3]
    where [Table3].SecondID = [Table2].SecondID
    order by [Table3].[Name] ASC) as AnyOneName
from [Table1]
join [Table2] on [Table2].FirstID = [Table1].FirstID

select distinct [Table1].FirstID, [Table1].MyParameter1, [Table1].MyParameter2,
   (select MIN([Table3].[Name]) from [Table3]
    where [Table3].SecondID = [Table2].SecondID) as FirstName
from [Table1]
join [Table2] on [Table2].FirstID = [Table1].FirstID

select distinct [Table1].FirstID, [Table1].MyParameter1, [Table1].MyParameter2,
   (select MAX([Table3].[Name]) from [Table3]
    where [Table3].SecondID = [Table2].SecondID) as LastName
from [Table1]
join [Table2] on [Table2].FirstID = [Table1].FirstID