Study/Oracle
Update Subquery
하늘바램
2014. 3. 4. 15:58
UPDATE TABLE1
SET TABLE1.COLUMN1 = (SELECT COL1 FROM TABLE2 WHERE TABLE2.COL2 = TABLE1.COLUMN2 AND TABLE2.COL3 = TABLE1.COLUMN3)
SET TABLE1.COLUMN1 = (SELECT COL1 FROM TABLE2 WHERE TABLE2.COL2 = TABLE1.COLUMN2 AND TABLE2.COL3 = TABLE1.COLUMN3)