找李雄川问的sql

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