Hey.

There are 3 tables

  • param (id, name)
  • paramValue (id, paramId, value)
  • paramValueCode (id, paramId, value, localizationKey)

If paramValue.Value = paramValueCode.Value , then choose paramValueCode.localizationKey otherwise paramValue.Value . At the exit you need:

 param, value, isLocalizationKey

Thank you in advance.

Figured out

 select case when t.localizationKey is null then t.value else t.localizationKey end as value, case when t.localizationKey is null then 0 else 1 end as isLocalizationKey from( select pv.value, (select localizationKey from ParamValueCode pvc where pvc.value = pv.value and pvk.paramId = pv.paramId) as localizationKey from param p join paramValue pv on p.id = pv.paramId) t

    1 answer 1

     select name as param, case when paramValue.Value = paramValueCode.Value then paramValueCode.localizationKey else paramValue.Value end as value, LocalizationKey from param join paramValue on param.id = paramValue.paramid join paramValueCode on param.id = paramValueCode.paramid

    case