看看我的INSERT的SQL语句，错在哪里呢？

[eastnet]

我用的是Access2000,Delphi7调试，
TmpTable2 :
Code PieceWork
1 130.00
2 210.00
--------------------------
PayTbl:
PayYear PayMonth Code Name BasePay PiecePay ...
....
2003 4 ........................
2003 5 1 AA 300.00 0
2003 5 2 BB 300.00 0
....
--------------------------
现将TmpTable2的PieceWork插入PayTbl的PiecePay中且条件是PiecePay的Payyerar=2003,PayMonth=5,且两表Code对应,我用这条ＳＱＬ语句,没有通过：

代码如下：
INSERT INTO PayTbl(PiecePay)
SELECT a.PieceWork FROM TmpTable2 a,PiecePay b
WHERE b.Code=a.Code AND b.PayYear=2003 AND b.PayMonth=5
（大家帮我看看，谢谢啦！）

[BBQ]

小黑可够快!
up支持小黑的答案

Update PayTbl SET PiecePay=a.PieceWork
From TmpTable2 a
Where PayTbl.Code=a.Code AND
PayTbl.PayYear=2003 AND PayTbl.PayMonth=5

[psxfghost]

pieceWork和piecePay的字段类型是不是不一致哦??

[psxfghost]

最好给出出错提示

[happydreamer]

update PayTbl
set Piecepay=a.PieceWork
from TmpTable2 a
WHERE PayTbl.Code=a.Code AND PayTbl.PayYear=2003 AND PayTbl.PayMonth=5

[dlkfth]

SELECT a.PieceWork into #tmp FROM TmpTable2 a,PiecePay b
WHERE b.Code=a.Code AND b.PayYear=2003 AND b.PayMonth=5
你先插入到临时表里，如果成功语句没有错

那就是违反约束

[caiyunxia]

update PayTbl set PiecePay=PieceWork
from A
WHERE PayTbl .Code=a.Code AND PayTbl .PayYear=2003 AND PayTbl .PayMonth=5

[psxfghost]

^_^,现在才懂你的意思!
可惜被高手抢答了!
唉.........

[eastnet]

谢谢各位大虾，散分。