update GADATA0011.EMPLOYEE set GADATA0011.EMPLOYEE.STRCARDNO=GADATA0011.ZDQVIEW.STREMPLOYEECODE from GADATA0011.EMPLOYEE,GADATA0011.ZDQVIEW where
GADATA0011.EMPLOYEE.STRCARDNO=GADATA0011.ZDQVIEW.STRCARDNO
GADATA0011.EMPLOYEE.STRCARDNO=GADATA0011.ZDQVIEW.STRCARDNO
解决方案 »
- oracle 安装问题
- sql语句问题~~
- Oracle 11g 表中多字段删除问题,求教
- oracle可以跨机建数据库吗?
- 存储过程怎么写?
- 初学oracle的两个问题
- 请问大侠几个oracle 9i的问题 谢谢..
- oracle中等连接和左连接是什么概念?还有外连接和内连接都是什么?
- 除了关系数据库外,听说还有个实时数据库(内存数据库),是啥呀?讨论讨论!
- Oracle数据库中,千万级数据量,筛选条件在一个字段里面,求大神指点SQL怎么啊!一千万的数据,匹配某一个字段中以逗号分开的多个值,如何写sql提高查询效率
- 急~~~~~~~~~~~~~~~~~~~~在线等ing......
- 请问怎么更新这样的记录?
update GADATA0011.EMPLOYEE
set GADATA0011.EMPLOYEE.STRCARDNO=(select GADATA0011.ZDQVIEW.STREMPLOYEECODE from GADATA0011.EMPLOYEE,GADATA0011.ZDQVIEW
where GADATA0011.EMPLOYEE.STRCARDNO=GADATA0011.ZDQVIEW.STRCARDNO)
update GADATA0011.EMPLOYEE set
GADATA0011.EMPLOYEE.STRCARDNO=
(select STREMPLOYEECODE from GADATA0011.ZDQVIEW where
GADATA0011.ZDQVIEW.STRCARDNO=GADATA0011.EMPLOYEE.STRCARDNO)
update GADATA0011.EMPLOYEE set GADATA0011.EMPLOYEE.STRCARDNO= select GADATA0011.ZDQVIEW.STREMPLOYEECODE from GADATA0011.EMPLOYEE,GADATA0011.ZDQVIEW where
GADATA0011.EMPLOYEE.STRCARDNO=GADATA0011.ZDQVIEW.STRCARDNO
GADATA0011.EMPLOYEE.STRCARDNO=
(
select STREMPLOYEECODE from GADATA0011.ZDQVIEW where
GADATA0011.ZDQVIEW.STRCARDNO=GADATA0011.EMPLOYEE.STRCARDNO)
where exists (
select STREMPLOYEECODE from GADATA0011.ZDQVIEW where
GADATA0011.ZDQVIEW.STRCARDNO=GADATA0011.EMPLOYEE.STRCARDNO
)楼主的语法来自SQL Server吧,:)