質問編集履歴
2
一部テーブル名間違えていたので修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -32,7 +32,7 @@
|
|
|
32
32
|
UPDATE MST M
|
|
33
33
|
SET M.PRICE = (SELECT W.PRICE FROM WRK W WHERE
|
|
34
34
|
M.CORD =W.CORD AND
|
|
35
|
-
M.PRICE <>
|
|
35
|
+
M.PRICE <> W.PRICE)
|
|
36
36
|
|
|
37
37
|
WHERE
|
|
38
38
|
M.CORD = (SELECT WW.CORD FROM WRK WW,MST MM
|
1
一部テーブル名間違えていたので直しました。
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -35,9 +35,9 @@
|
|
|
35
35
|
M.PRICE <> WW.PRICE)
|
|
36
36
|
|
|
37
37
|
WHERE
|
|
38
|
-
M.CORD = (SELECT
|
|
38
|
+
M.CORD = (SELECT WW.CORD FROM WRK WW,MST MM
|
|
39
39
|
WHERE
|
|
40
|
-
|
|
40
|
+
WW.CORD IN (MM.CORD) AND
|
|
41
41
|
MM.PRICE <> WW.PRICE);
|
|
42
42
|
|
|
43
43
|
|