質問編集履歴
2
一部テーブル名間違えていたので修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -66,7 +66,7 @@
|
|
|
66
66
|
|
|
67
67
|
M.CORD =W.CORD AND
|
|
68
68
|
|
|
69
|
-
M.PRICE <> W
|
|
69
|
+
M.PRICE <> W.PRICE)
|
|
70
70
|
|
|
71
71
|
|
|
72
72
|
|
1
一部テーブル名間違えていたので直しました。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -72,11 +72,11 @@
|
|
|
72
72
|
|
|
73
73
|
WHERE
|
|
74
74
|
|
|
75
|
-
M.CORD = (SELECT W.CORD FROM W
|
|
75
|
+
M.CORD = (SELECT WW.CORD FROM WRK WW,MST MM
|
|
76
76
|
|
|
77
77
|
WHERE
|
|
78
78
|
|
|
79
|
-
WW
|
|
79
|
+
WW.CORD IN (MM.CORD) AND
|
|
80
80
|
|
|
81
81
|
MM.PRICE <> WW.PRICE);
|
|
82
82
|
|