update ejsjdictionary t5 set t5.wordinputperson='538' where
t5.ejoid in( select
/* t2.oid,
t2.industryname,
t2.industrycode,
t2.serialnumber,
t1.ejoid,
t1.companyoid,
t1.diccode,
t1.industryoid,
t1.chwordname,
t1.enwordname,
*/
t1.ejoid
from ejsjindustry t,ejsjdictionary t1,ejsjindustry t2
where t.oid = t1.industryoid
and substr(t.serialnumber,1,length( t2.serialnumber))=t2.serialnumber
and t.companyoid=t2.companyoid
and t2.struid is null
and t2.oid=602)
修改根词类节点下所有词条录入人信息