質問編集履歴
2
修正依頼があったため
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -58,7 +58,7 @@
|
|
|
58
58
|
|
|
59
59
|
SELECT * from テーブルA a
|
|
60
60
|
|
|
61
|
-
left join テーブルB b on (a.CD_A = b.CD_A and a.CD_B = b.CD_B and a.CD_
|
|
61
|
+
left join テーブルB b on (a.CD_A = b.CD_A and a.CD_B = b.CD_B and a.CD_D = b.CD_D)
|
|
62
62
|
|
|
63
63
|
left join テーブルC c on (b.CD_A = c.CD_A and b.CD_B = c.CD_B and b.CD_E = c.CD_E)
|
|
64
64
|
|
1
プログラムの記述に間違いありとご指摘を頂きました。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -58,9 +58,9 @@
|
|
|
58
58
|
|
|
59
59
|
SELECT * from テーブルA a
|
|
60
60
|
|
|
61
|
-
left join テーブルB b on (a.CD_A =b.CD_A and a.CD_B = b.CD_B and a.CD_C
|
|
61
|
+
left join テーブルB b on (a.CD_A = b.CD_A and a.CD_B = b.CD_B and a.CD_C = b.CD_C)
|
|
62
62
|
|
|
63
|
-
left join テーブルC c on (b.CD_A =c.CD_A and b.CD_B = c.CD_B and b.CD_E = c.CD_E)
|
|
63
|
+
left join テーブルC c on (b.CD_A = c.CD_A and b.CD_B = c.CD_B and b.CD_E = c.CD_E)
|
|
64
64
|
|
|
65
65
|
```
|
|
66
66
|
|
|
@@ -74,7 +74,7 @@
|
|
|
74
74
|
|
|
75
75
|
select * from テーブルA a,テーブルB b,テーブルC c
|
|
76
76
|
|
|
77
|
-
where (a.CD_A = b.CD_A and a.CD_B = b.CD_B and a.CD_D = b.CD_) and (b.CD_A = c.CD_A and b.CD_B = c.CD_B and b.CD_E = c.CD_E)
|
|
77
|
+
where (a.CD_A = b.CD_A and a.CD_B = b.CD_B and a.CD_D = b.CD_D) and (b.CD_A = c.CD_A and b.CD_B = c.CD_B and b.CD_E = c.CD_E)
|
|
78
78
|
|
|
79
79
|
```
|
|
80
80
|
|