UPDATE dbo.Table2
SET dbo.Table2.ColB = dbo.Table2.ColB + dbo.Table1.ColB
FROM dbo.Table2
INNER JOIN dbo.Table1
ON (dbo.Table2.ColA = dbo.Table1.ColA)

Posted by give at 痞客邦 PIXNET Comments(0) Trackback(0) Hits(92)

Shorten Url Recommend to Front page Forward by E-mail Forward to Guestbook