回答編集履歴
1
表示調整
test
CHANGED
@@ -89,3 +89,35 @@
|
|
89
89
|
|
90
90
|
|
91
91
|
```
|
92
|
+
|
93
|
+
|
94
|
+
|
95
|
+
# 表示調整
|
96
|
+
|
97
|
+
```SQL
|
98
|
+
|
99
|
+
set @no=null,@name=null;
|
100
|
+
|
101
|
+
select
|
102
|
+
|
103
|
+
if(@no=no,'',@no:=no) as no,
|
104
|
+
|
105
|
+
if(@name=name,'',@name:=name) as name,
|
106
|
+
|
107
|
+
val from(
|
108
|
+
|
109
|
+
select no,name,sex as val,1 as sort1,0 as sort2 from member
|
110
|
+
|
111
|
+
union all
|
112
|
+
|
113
|
+
select t1.no,t1.name,t3.data_name,2,t2.like_no from member as t1
|
114
|
+
|
115
|
+
inner join like_member as t2 on t1.no=t2.like_member_no
|
116
|
+
|
117
|
+
inner join like_data as t3 on t2.like_data_no=t3.data_no
|
118
|
+
|
119
|
+
) as sub
|
120
|
+
|
121
|
+
order by sub.no,sub.sort1,sub.sort2;
|
122
|
+
|
123
|
+
```
|