从另一个表更新 [英] update from another table

问题描述

需要从查询中运行更新。



请更正循环的例程

 更新 DEPOSIT  SET  IDNO = PAY_PAYMAST.IDNO  WHERE  DEPOSIT.EMPNO = PAY_PAYMAST.EMPNO 

谢谢

解决方案

对于这种情况，请使用：

 更新 t1  SET  t1.IDNO = t2.IDNO 
  FROM  DEPOSIT  AS  t1  INNER   JOIN  PAY_PAYMAST  AS  t2  ON  t1.EMPNO = t2.EMPNO 

注意：如果 IDNO 字段是 DEPOSIT 表的主键，则更新可能会失败。

UPDATE DEPOSIT

SET IDNO = PAY_PAYMAST.IDNO

来自存款，PAYMAST，其中DEPOSIT.EMPNO = PAY_PAYMAST.EMPNO

Need to run an update from the query.

Please correct the routine for the loop

UPDATE DEPOSIT SET IDNO=PAY_PAYMAST.IDNO WHERE DEPOSIT.EMPNO=PAY_PAYMAST.EMPNO

Thanks

解决方案

For such of situation, use this:

UPDATE t1 SET t1.IDNO=t2.IDNO
FROM DEPOSIT AS t1 INNER JOIN PAY_PAYMAST AS t2 ON t1.EMPNO=t2.EMPNO

Note: update may fail if IDNO field is primary key of DEPOSIT table.

UPDATE DEPOSIT
SET IDNO = PAY_PAYMAST.IDNO
FROM DEPOSIT, PAYMAST WHERE DEPOSIT.EMPNO=PAY_PAYMAST.EMPNO

这篇关于从另一个表更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！