将A表的值更新到B表上,AB表有关联

eg:

update A set InAmount =b.InAmount
 from A a inner join B b on( a.ID=b.PRID)

posted @ 2015-04-14 14:22  咕咕传说  阅读(388)  评论(0)    收藏  举报