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'