[SQL ] update問題
UPDATE
(
SELECT
A.FILLED
FROM
BIG5CHK A,TTB1217_2 B
WHERE
A.BIG5=B.BIG5
AND
B.THECHECK = 'Y'
AND
B.THESHOW='N'
)
SET FILLED = 'Y'
[BIG5CHK](BIG5/FILLED/CHK)
A1A1 N N
A1A2 N N
[TTB1217_2](BIG5/THECHECK/THESHOW)
A1A1 Y N
A1A2 N N
主要是想把CHK table裡的FILLED改成Y
條件同上方括號內
但是下指令後卻出現
cannot modify a column which maps to a non key-preserved table
用的DB是ORACLE10G
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 219.87.182.126
推
12/20 00:54, , 1F
12/20 00:54, 1F
推
12/20 00:56, , 2F
12/20 00:56, 2F
推
12/20 00:58, , 3F
12/20 00:58, 3F
討論串 (同標題文章)
完整討論串 (本文為第 1 之 2 篇):