質問編集履歴
2
修正依頼があったため
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -28,7 +28,7 @@
|
|
|
28
28
|
|
|
29
29
|
```sql
|
|
30
30
|
SELECT * from テーブルA a
|
|
31
|
-
left join テーブルB b on (a.CD_A = b.CD_A and a.CD_B = b.CD_B and a.
|
|
31
|
+
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)
|
|
32
32
|
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)
|
|
33
33
|
```
|
|
34
34
|
|
1
プログラムの記述に間違いありとご指摘を頂きました。
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -28,15 +28,15 @@
|
|
|
28
28
|
|
|
29
29
|
```sql
|
|
30
30
|
SELECT * from テーブルA a
|
|
31
|
-
left join テーブルB b on (a.CD_A =b.CD_A and a.CD_B = b.CD_B and a.CD_C
|
|
31
|
+
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)
|
|
32
|
-
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)
|
|
32
|
+
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)
|
|
33
33
|
```
|
|
34
34
|
|
|
35
35
|
と書くか、
|
|
36
36
|
|
|
37
37
|
```sql
|
|
38
38
|
select * from テーブルA a,テーブルB b,テーブルC c
|
|
39
|
-
where (a.CD_A = b.CD_A and a.CD_B = b.CD_B and a.CD_D = b.
|
|
39
|
+
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)
|
|
40
40
|
```
|
|
41
41
|
|
|
42
42
|
で何か違いはあるものなのでしょうか？
|