在SQL中经常会碰到修改一个表的数据,但条件是根据关联另一个表来生成的
语句如下:
update table1 set table1.f1 = t2.f1 from table2 t2 where table1.f2 = t2.f2
如:根据IVR业务信息表修改IVR的拔打切片表内数据如下:
update TB_IVR_SW_STAT set TB_IVR_SW_STAT.province = b.province from TB_IVR_SW_INFO b
where TB_IVR_SW_STAT.calledid = b.calledid
语句如下:
update table1 set table1.f1 = t2.f1 from table2 t2 where table1.f2 = t2.f2
如:根据IVR业务信息表修改IVR的拔打切片表内数据如下:
update TB_IVR_SW_STAT set TB_IVR_SW_STAT.province = b.province from TB_IVR_SW_INFO b
where TB_IVR_SW_STAT.calledid = b.calledid