回答編集履歴

1

DISTINCTが抜けていたので追加

2015/04/10 02:17

投稿

kutsulog
kutsulog

スコア985

test CHANGED
@@ -8,7 +8,7 @@
8
8
 
9
9
  , U.userName
10
10
 
11
- , COUNT(T.toukouId) as tCount
11
+ , COUNT(DISTINCT T.toukouId) as tCount
12
12
 
13
13
  , COUNT(I.toukouId) as iCount
14
14