Untitled

select 
c."Name" as city,
scio."SmOpportunityId" as opportunity_identificator
from "SmCityInOpportunity" scio 
left join "City" c 
	on c."Id" = scio."SmCityId"