select Subject_id as contract_id prop_value as value zx value_desc as

1
2
3
4
select Subject_id as contract_id,prop_value as value,zx.value_desc as "Переодичность ОД"
from data_hub.atl_llc_prop_values aa
left join data_hub.atl_lll_cls_values zx on zx.value_code=aa.prop_value
where add_prop_cls='710064109'