insert into splhead(splhead.eformid,splhead.eformsn) select numpara.eformid,numpara.eformsn from numpara where splhead.num_sql=numpara.formno
有谁帮我看看我这样写对吗
update splhead set eformid=(select eformid from numpara where numpara.formno=splhead.num_spl ),eformsn=(select eformsn from numpara where numpara.formno=splhead.num_spl ),