1、从基本信息表中提出站名，然后更新数据表中站名字段:
UPDATE TMP_RAINSTATION SET STNM = B.STNM FROM TMP_RAINSTATION A INNER JOIN ST_STBPRP_B B ON A.STCD = B.STCD

2、有一个基本表tab1，
  id    name
  01     A
  02     A
  03     B
  04     C
  05     B
  06     D
 怎么删除name中重复的数据？
1、全部删除
delete from tb where name not in (select name from tb group by name having count(*) > 1)
2、保留一条（假设保留ID最小的）
delete from tb where not exists (select name , min(id) as id from tb group by name)
delete t1 from tab1 t1
where exists (select 1 from tab1 where name = t1.name and id < t1.id)