回答編集履歴
1
SQLが隠れるので行間を詰めます。
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
|
|