回答編集履歴

1

修正

2017/08/07 08:24

投稿

sazi
sazi

スコア25199

test CHANGED
@@ -10,8 +10,8 @@
10
10
 
11
11
  FROM TABLE_A A
12
12
 
13
- INNER JOIN TABLE_B B ON A.ID=B.ID AND A.XXX=0
13
+ LEFT JOIN TABLE_B B ON A.ID=B.ID AND A.XXX=0
14
14
 
15
- INNER JOIN TABLE_C C ON A.ID=C.ID AND A.XXX=1
15
+ LEFT JOIN TABLE_C C ON A.ID=C.ID AND A.XXX=1
16
16
 
17
17
  ```