邦幫我!

mrhxn

delete from czsj42;
insert into czsj42(c_dwbm,c_dwmc,name,sfz,sfgz_42) select c_dwbm,c_dwmc,name,sfz,sfgz from czsj where
    c_dwbm=210208 or c_dwbm=210212 or c_dwbm=130601 or c_dwbm=131100 or
    c_dwbm=090307 or c_dwbm=250102 or c_dwbm=090601;
update czsj42 set gzzr=sfgz_42*100;
update czsj42 set y_sno=dd_sno,y_ano=dd_ano(select (dd_sno,dd_ano) from dgdz42 where name=dd_name and sfz=dd_sfz);

在執(zhí)行到update czsj42 set y_sno=dd_sno,y_ano=dd_ano(select (dd_sno,dd_ano) from dgdz42 where name=dd_name and sfz=dd_sfz);
說是語法錯，停在了from上，我看不出錯在什么地方，請邦邦我(windows環(huán)境)

sgool

改成：
update czsj42 set （y_sno,y_ano)=((select dd_sno,dd_ano from dgdz42 where name=dd_name and sfz=dd_sfz));
試試。

mrhxn

謝謝!通過!