谁能给我优化这句SQL语句?现在需要花费1分51秒,提高一秒给十分!!!
wkoji 2003-02-21 11:02:51 UPDATE tblExlTempYear
SET tblExlTempYear.GDQC = tblExlTempMonth.GDQC
FROM tblExlTempYear,tblExlTempMonth
where tblExlTempMonth.GDXM=tblExlTempYear.GDXM and tblExlTempMonth.TXDZ=tblExlTempYear.TXDZ