oracle关联表更新表多个字段
来源:互联网 发布:网络通信 代码 编辑:程序博客网 时间:2024/05/02 00:13
update t_bas_sales_department_626 s
set (s.code,s.leave,s.pickup_self,s.delivery) =(select ofs.code,ofs.leave,ofs.pickup_self,ofs.delivery from
(select distinct os.code,
fs.leave,
fs.pickup_self,
fs.delivery
from t_bas_sales_department_626 os
inner join t_bas_sales_department@ows2foss2 fs
on os.code = fs.code
where os.active = 'Y'
and fs.active = 'Y'
AND (os.leave != fs.leave or
os.pickup_self != fs.pickup_self or
os.delivery != fs.delivery)) ofs
where s.code = ofs.code)
where exists (
select 1 from (select distinct os.code,
fs.leave,
fs.pickup_self,
fs.delivery
from t_bas_sales_department_626 os
inner join t_bas_sales_department@ows2foss2 fs
on os.code = fs.code
where os.active = 'Y'
and fs.active = 'Y'
AND (os.leave != fs.leave or
os.pickup_self != fs.pickup_self or
os.delivery != fs.delivery)) ofs
where s.code = ofs.code
) and s.active='Y'
set (s.code,s.leave,s.pickup_self,s.delivery) =(select ofs.code,ofs.leave,ofs.pickup_self,ofs.delivery from
(select distinct os.code,
fs.leave,
fs.pickup_self,
fs.delivery
from t_bas_sales_department_626 os
inner join t_bas_sales_department@ows2foss2 fs
on os.code = fs.code
where os.active = 'Y'
and fs.active = 'Y'
AND (os.leave != fs.leave or
os.pickup_self != fs.pickup_self or
os.delivery != fs.delivery)) ofs
where s.code = ofs.code)
where exists (
select 1 from (select distinct os.code,
fs.leave,
fs.pickup_self,
fs.delivery
from t_bas_sales_department_626 os
inner join t_bas_sales_department@ows2foss2 fs
on os.code = fs.code
where os.active = 'Y'
and fs.active = 'Y'
AND (os.leave != fs.leave or
os.pickup_self != fs.pickup_self or
os.delivery != fs.delivery)) ofs
where s.code = ofs.code
) and s.active='Y'
- oracle关联表更新表多个字段
- oracle 多表关联更新,需要更新的字段在另一个表里
- oracle下表关联更新
- oracle 多表关联 更新
- Oracle多表关联更新
- oracle 更新关联表数据
- Oracle两表关联更新
- oracle多表关联更新
- oracle两表关联更新
- Oracle多表关联更新
- Oracle 两表关联更新
- oracle两表关联更新
- ORACLE多表关联更新
- [ORACLE]关联表更新数据
- oracle多表关联更新
- 2张表关联字段的关联更新,代码如下:
- ORACLE中的多表关联更新
- oracle UPDATE 多表关联更新
- shell date 用法总结
- istringstream对象可以绑定一行字符串,然后以空格为分隔符把改行分隔开来
- ab和LoadRunner的区别,及ab的运用方法
- tamcat6.0局域网访问
- 跟我一起写 Makefile(二)
- oracle关联表更新表多个字段
- qvfb的编译与使用
- VS2008,vs2010 快捷键大全 c#
- oracal判断某字段值中是否包含某字符串
- cifs上传docx文件损坏问题小记
- ZFS cloudera CDH plug in with Hadoop
- 在程序出错时创建CrashDump文件
- xentrace Couldn't enable trace buffers: Invalid argument 解决
- 关于如何由DLL得到函数声明的方法