回答編集履歴

1

SQLが隠れるので行間を詰めます。

2017/09/22 20:34

投稿

退会済みユーザー
test CHANGED
@@ -8,13 +8,9 @@
8
8
 
9
9
  -- CREATE TABLE table2 (C int, D varchar(2), E varchar(2));
10
10
 
11
-
12
-
13
11
  -- INSERT INTO table1 VALUES ('aa','1'),('bb','2'),('cc','3'),('dd','4');
14
12
 
15
13
  -- INSERT INTO table2 VALUES (22, 'd1', 'aa'),(55,'d1','dd'),(33,'d1','cc'),(11,'d1','bb'),(66,'d1','aa'),(22,'d2','8'),(66,'d2','10'),(55,'d2','3'),(33,'d2',5),(11,'d2','2');
16
-
17
-
18
14
 
19
15
  UPDATE table2, (SELECT C, B FROM table2 INNER JOIN table1 ON table1.A = table2.E) tmp
20
16