質問編集履歴
1
修正
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
|
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
|
27
|
+
left outer join table.member as mem on mem.id = t1.member_id) as number
|
28
28
|
|
29
29
|
```
|