select
t1.Id, t2.Name, t2.Description, t1.MinValue, t1.MaxValue, t3.Symbol as Unit
from TestTypeParameters as t1 join
Parameters as t2 on t1.Parameter = t2.Id left join
Units as t3 on t1.Unit = t3.Id
where TestType = @TestType