多表:update JC_KEYWORD a set a.classifyName = (select b.classify from classify b where a.classifyId=b.classifyId) where exists (select 1 from classify b where a.classifyid=b.classifyid)
单表:update rpt_indc b set b.parentindcname = (select a.indcname from rpt_indc a where b.parentindcid= a.indcid )