update photo_asset_station
set photo_asset_station.city_org_code = (select o_org.ORG_NO
from o_org
where substr(o_org.ORG_NAME, 3, 2) = substr(photo_asset_station.city_code, 1, 2)and o_org.ORG_TYPE =3 )
where uuid is not null
update photo_asset_station
set photo_asset_station.org_no = (select o_org.ORG_NO
from o_org
where instr(o_org.ORG_NAME ,substr(photo_asset_station.district_code, 1, 2))>0 and o_org.ORG_TYPE =4 )
where uuid is not null