UPDATE table1 a
SET table1_column = (SELECT table2_column
FROM table2
WHERE ID = a.ID)
文章標籤
全站熱搜
- 6月 10 週四 201015:16
[Oracle] PL/SQL 用其它的 Table 來更新資料(Update From Table)
UPDATE table1 a
SET table1_column = (SELECT table2_column
FROM table2
WHERE ID = a.ID)