SQL 命令未正确结束，大家帮我看看，我没有分了

Question

update GADATA0011.EMPLOYEE set GADATA0011.EMPLOYEE.STRCARDNO=GADATA0011.ZDQVIEW.STREMPLOYEECODE from GADATA0011.EMPLOYEE,GADATA0011.ZDQVIEW where 
GADATA0011.EMPLOYEE.STRCARDNO=GADATA0011.ZDQVIEW.STRCARDNO

Answer 1

用这个试试：
update GADATA0011.EMPLOYEE 
set GADATA0011.EMPLOYEE.STRCARDNO=(select GADATA0011.ZDQVIEW.STREMPLOYEECODE from GADATA0011.EMPLOYEE,GADATA0011.ZDQVIEW 
where GADATA0011.EMPLOYEE.STRCARDNO=GADATA0011.ZDQVIEW.STRCARDNO)

Answer 2

update语句不是这么写的，不要from
update GADATA0011.EMPLOYEE set 
GADATA0011.EMPLOYEE.STRCARDNO=
(select STREMPLOYEECODE from GADATA0011.ZDQVIEW where 
GADATA0011.ZDQVIEW.STRCARDNO=GADATA0011.EMPLOYEE.STRCARDNO)

Answer 3

少了select吧
update GADATA0011.EMPLOYEE set GADATA0011.EMPLOYEE.STRCARDNO= select GADATA0011.ZDQVIEW.STREMPLOYEECODE from GADATA0011.EMPLOYEE,GADATA0011.ZDQVIEW where 
GADATA0011.EMPLOYEE.STRCARDNO=GADATA0011.ZDQVIEW.STRCARDNO

Answer 4

update GADATA0011.EMPLOYEE set 
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吧，：）