質問編集履歴
2
SQK文の字下げ対応
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -44,19 +44,21 @@
|
|
|
44
44
|
|
|
45
45
|
AFTER INSERT
|
|
46
46
|
|
|
47
|
-
AS
|
|
47
|
+
AS
|
|
48
48
|
|
|
49
|
-
|
|
49
|
+
BEGIN
|
|
50
50
|
|
|
51
|
-
|
|
51
|
+
update [テーブルB]
|
|
52
52
|
|
|
53
|
-
|
|
53
|
+
set [テーブルB].key1 = [テーブルA].key2
|
|
54
54
|
|
|
55
|
-
|
|
55
|
+
from [テーブルA]
|
|
56
56
|
|
|
57
|
-
|
|
57
|
+
where [テーブルB].key3 = [テーブルA].key3 and
|
|
58
58
|
|
|
59
|
+
[テーブルB].key4 = [テーブルA].key4 and
|
|
60
|
+
|
|
59
|
-
[テーブルA].key5 = 0;
|
|
61
|
+
[テーブルA].key5 = 0;
|
|
60
62
|
|
|
61
63
|
END
|
|
62
64
|
|
1
省略していたwhere句を追記しました。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -52,7 +52,11 @@
|
|
|
52
52
|
|
|
53
53
|
from [テーブルA]
|
|
54
54
|
|
|
55
|
+
where [テーブルB].key3 = [テーブルA].key3 and
|
|
56
|
+
|
|
57
|
+
[テーブルB].key4 = [テーブルA].key4 and
|
|
58
|
+
|
|
55
|
-
|
|
59
|
+
[テーブルA].key5 = 0;
|
|
56
60
|
|
|
57
61
|
END
|
|
58
62
|
|