質問編集履歴

1

修正

2016/11/18 05:28

投稿

Citra01
Citra01

スコア13

test CHANGED
File without changes
test CHANGED
@@ -18,12 +18,12 @@
18
18
 
19
19
  ,(select GROUP_CONCAT(distinct mem.name SEPARATOR ',') from table.table1 as t1
20
20
 
21
- left outer join table.member as mem on mem.id = t1.member_id) as sales
21
+ left outer join table.member as mem on mem.id = t1.member_id) as name
22
22
 
23
23
 
24
24
 
25
25
  ,(select GROUP_CONCAT(mem.number SEPARATOR ',') from table.table1 as t1
26
26
 
27
- left outer join table.member as mem on mem.id = t1.member_id) as sales
27
+ left outer join table.member as mem on mem.id = t1.member_id) as number
28
28
 
29
29
  ```