从一个表到另一个表的Netezza UPDATE [英] Netezza UPDATE from one table to another

问题描述

这是我在Netezza中无法使用的查询:

This is my query that does not work in Netezza:

UPDATE TABLE1 A
SET A.COL1= (SELECT DISTINCT B.COL1 FROM TABLE2 B WHERE B.ID= A.ID AND B.DeptID=104)
WHERE A.DeptID=3

如何重新编写此查询? 请帮忙.

How do I re-write this query? Please help.

推荐答案

UPDATE TABLE1 A
SET A.COL1 = B.COL1
FROM TABLE2 B
WHERE
A.ID = B.ID AND 
A.DeptID = 3 AND 
B.DeptID = 104;

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