select Subject_id as contract_id prop_value as value zx value_desc as

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'