回答編集履歴
1
表示調整
answer
CHANGED
|
@@ -43,4 +43,20 @@
|
|
|
43
43
|
inner join like_data as t3 on t2.like_data_no=t3.data_no
|
|
44
44
|
order by no,sort1,sort2;
|
|
45
45
|
|
|
46
|
+
```
|
|
47
|
+
|
|
48
|
+
# 表示調整
|
|
49
|
+
```SQL
|
|
50
|
+
set @no=null,@name=null;
|
|
51
|
+
select
|
|
52
|
+
if(@no=no,'',@no:=no) as no,
|
|
53
|
+
if(@name=name,'',@name:=name) as name,
|
|
54
|
+
val from(
|
|
55
|
+
select no,name,sex as val,1 as sort1,0 as sort2 from member
|
|
56
|
+
union all
|
|
57
|
+
select t1.no,t1.name,t3.data_name,2,t2.like_no from member as t1
|
|
58
|
+
inner join like_member as t2 on t1.no=t2.like_member_no
|
|
59
|
+
inner join like_data as t3 on t2.like_data_no=t3.data_no
|
|
60
|
+
) as sub
|
|
61
|
+
order by sub.no,sub.sort1,sub.sort2;
|
|
46
62
|
```
|