SQL两表关系

Question

本人刚刚学SQL 
希望大家帮我指点下写个语句
a表如下字段期末余额本币 providerid
252364.2            5
16422.1            9
8445.5            10
2799            13
89226            14
358965            15
2113            33
235178.8            34
91714.51            35
3525            37
468032            42
718075.1            43b表如下字段期末余额本币 providerid
                     5
            9
           10
                    13
           14
           15
           33
                    34
                    35
           37
           42
                    43根据providerid关联 将a表的期末余额本币字段【复制到】b表的期末余额本币字段 
知道的帮我下  谢谢 

Answer 1

update tb set 期末余额本币=ta.期末余额本币
from ta where ta.providerid=tb.providerid

Answer 2

a表期末余额本币 providerid        
252364.2          5 
16422.1           9 
8445.5           10 
2799             13 
89226            14 
358965           15 
2113             33 
235178.8         34 
91714.51         35 
3525             37 
468032           42 
718075.1         43b表期末余额本币 providerid        
                 5 
                 9 
                10 
                13 
                14 
                15 
                33 
                34 
                35 
                37 
                42 
                43

Answer 3

update 
  b
set
  期末余额本币=a.期末余额本币
from
  a
where
  a.providerid=b.providerid

Answer 4

update 
  b set
  [期末余额本币]=a.[期末余额本币] from
  awhere
  a.providerid=b.providerid

Answer 5

这是一个表插入问题，语句，insert into a (b,c) select b,c from d.