質問編集履歴
2
文脈を修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -66,9 +66,9 @@
|
|
66
66
|
|
67
67
|
T1
|
68
68
|
|
69
|
-
aaa VERCAHR2
|
69
|
+
aaa VERCAHR2 P
|
70
70
|
|
71
|
-
bbb VERCAHR2
|
71
|
+
bbb VERCAHR2 P
|
72
72
|
|
73
73
|
ccc NUMBER
|
74
74
|
|
@@ -76,9 +76,9 @@
|
|
76
76
|
|
77
77
|
T2
|
78
78
|
|
79
|
-
aaa VERCAHR2
|
79
|
+
aaa VERCAHR2 P
|
80
80
|
|
81
|
-
bbb VERCAHR2
|
81
|
+
bbb VERCAHR2 P
|
82
82
|
|
83
83
|
fff NUMBER
|
84
84
|
|
1
書式の改善
test
CHANGED
File without changes
|
test
CHANGED
@@ -34,6 +34,8 @@
|
|
34
34
|
|
35
35
|
```ここに言語を入力
|
36
36
|
|
37
|
+
|
38
|
+
|
37
39
|
SELECT
|
38
40
|
|
39
41
|
T1.aaa,
|
@@ -50,6 +52,36 @@
|
|
50
52
|
|
51
53
|
WHERE T1.aaa = T2.aaa
|
52
54
|
|
55
|
+
AND T1.bbb = T2.bbb
|
56
|
+
|
57
|
+
|
58
|
+
|
53
59
|
```
|
54
60
|
|
61
|
+
|
62
|
+
|
55
63
|
このような記述の仕方ではダメなのでしょうか。
|
64
|
+
|
65
|
+
|
66
|
+
|
67
|
+
T1
|
68
|
+
|
69
|
+
aaa VERCAHR2
|
70
|
+
|
71
|
+
bbb VERCAHR2
|
72
|
+
|
73
|
+
ccc NUMBER
|
74
|
+
|
75
|
+
|
76
|
+
|
77
|
+
T2
|
78
|
+
|
79
|
+
aaa VERCAHR2
|
80
|
+
|
81
|
+
bbb VERCAHR2
|
82
|
+
|
83
|
+
fff NUMBER
|
84
|
+
|
85
|
+
|
86
|
+
|
87
|
+
項目数は完全一致です。
|