teratail header banner
teratail header banner
質問するログイン新規登録

質問編集履歴

3

誤字

2017/10/18 05:28

投稿

nyansam
nyansam

スコア6

title CHANGED
File without changes
body CHANGED
@@ -15,7 +15,6 @@
15
15
  SELECT '1'
16
16
  FROM TABLE b
17
17
           WHERE b.CD = a.CD
18
- AND c.NM <> a.NM
19
18
  GROUP BY b.NM, a.CD, a.NM ) )
20
19
 
21
20
  ```

2

修正

2017/10/18 05:28

投稿

nyansam
nyansam

スコア6

title CHANGED
File without changes
body CHANGED
@@ -9,7 +9,7 @@
9
9
  UPDATE TABLE a
10
10
  SET a.NM = (SELECT b.NM
11
11
     FROM TABLE b
12
-          WHERE b.CD = b.CD
12
+          WHERE b.CD = a.CD
13
13
  GROUP BY b.NM, a.CD, a.NM )
14
14
  WHERE EXISTS (
15
15
  SELECT '1'

1

ソース修正

2017/10/18 05:28

投稿

nyansam
nyansam

スコア6

title CHANGED
File without changes
body CHANGED
@@ -7,7 +7,7 @@
7
7
  ###該当のソースコード
8
8
  ```
9
9
  UPDATE TABLE a
10
- SET a.NAME = (SELECT b.NM
10
+ SET a.NM = (SELECT b.NM
11
11
     FROM TABLE b
12
12
           WHERE b.CD = b.CD
13
13
  GROUP BY b.NM, a.CD, a.NM )
@@ -15,7 +15,7 @@
15
15
  SELECT '1'
16
16
  FROM TABLE b
17
17
           WHERE b.CD = a.CD
18
- AND c.NM <> a._NM
18
+ AND c.NM <> a.NM
19
19
  GROUP BY b.NM, a.CD, a.NM ) )
20
20
 
21
21
  ```