Update Subquery

UPDATE TABLE1
SET TABLE1.COLUMN1 = (SELECT COL1 FROM TABLE2 WHERE TABLE2.COL2 = TABLE1.COLUMN2 AND TABLE2.COL3 = TABLE1.COLUMN3)