CODEWITHSUNDEEP
sqlnetezzaansi-sql
ozzboy
ozzboy

Reputation: 2720

Netezza UPDATE from one table to another

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.

Upvotes: 6

Views: 30539

Answers (1)

Donal
Donal

Reputation: 32713

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

Upvotes: 13

Related Questions