質問編集履歴
1
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -8,8 +8,8 @@
|
|
|
8
8
|
|
|
9
9
|
```SQL
|
|
10
10
|
,(select GROUP_CONCAT(distinct mem.name SEPARATOR ',') from table.table1 as t1
|
|
11
|
-
left outer join table.member as mem on mem.id = t1.member_id) as
|
|
11
|
+
left outer join table.member as mem on mem.id = t1.member_id) as name
|
|
12
12
|
|
|
13
13
|
,(select GROUP_CONCAT(mem.number SEPARATOR ',') from table.table1 as t1
|
|
14
|
-
left outer join table.member as mem on mem.id = t1.member_id) as
|
|
14
|
+
left outer join table.member as mem on mem.id = t1.member_id) as number
|
|
15
15
|
```
|