update 两表 updateHR_USER_ZSJ_推广_okaseta.newou=(selectnewoufromisc_baseorgbwherea.所属组织=b.sysdataid) whereexists(select1fromHR_USER_ZSJ_推广_okcwherea.所属组织=c.sysdataid)
update login_name updateHR_USER_ZSJ_推广_oksetlogin_name=fn_getpy_1(名称)||'@'|| (casewhen newoulike'%潮州供电局%'then'cz.gd.csg.cn'when newoulike'%东莞供电局%'then'dg.gd.csg.cn'whennewoulike'%佛山供电局%'then'fs.gd.csg.cn'when newoulike'%河源供电局%'then'hy.gd.csg.cn'whennewoulike'%惠州供电局%'then'hz.gd.csg.cn'when newoulike'%江门供电局%'th
关联查询 selectt.*,u.hrdeptid,u.newou,b.newoufromisc_user_配网用户名重复t,isc_useru,isc_baseorgb wheret.用户id=u.idandu.newou=b.newou
fn_getpy selectc.*,fn_getpy(c_name)||'@'|| (casewhennewoulike'%潮州%'then'cz.gd.csg.cn'when newoulike'%东莞%'then'dg.gd.csg.cn'whennewoulike'%佛山%'then'fs.gd.csg.cn'when newoulike'%河源%'then'hy.gd.csg.cn'whennewoulike'%惠州%'then'hz.gd.csg.cn'when newoulike'%江门%'then'jm.gd.csg.cn'whennewoulike'%揭阳%'then'jy.gd