Untitled

select 
c.name as city,
scio.smopportunityid as opportunity_identificator
from vw_ods_bpm_soft.vw_smcityinopportunity scio 
left join vw_ods_bpm_soft.vw_city c 
	on c.id = scio.smcityid;