How do I end up with this query

select distinct navn, (select top 1 drugid from dbo.Prod_GrundData_Laegemiddel x where x.navn = Prod_GrundData_Laegemiddel.navn) drugid
from dbo.Prod_GrundData_Laegemiddel
where navn like 'panodil%'

I'm using V 2.5 SelfServicing

Please check the Scalar query expressions section in the docs. At the following path: Using the generated code -> Field expressions and aggregates -> Expressions

P.S. There is a code example there.

Thanks