回答編集履歴

1

修正

2017/08/07 08:24

投稿

sazi
sazi

スコア25430

answer CHANGED
@@ -4,6 +4,6 @@
4
4
  ```SQL
5
5
  SELECT A.ID
6
6
  FROM TABLE_A A
7
- INNER JOIN TABLE_B B ON A.ID=B.ID AND A.XXX=0
7
+ LEFT JOIN TABLE_B B ON A.ID=B.ID AND A.XXX=0
8
- INNER JOIN TABLE_C C ON A.ID=C.ID AND A.XXX=1
8
+ LEFT JOIN TABLE_C C ON A.ID=C.ID AND A.XXX=1
9
9
  ```