表A:
name value order
------ ------- -------
member 1 0
member 4 1
member 2 2
member 10 3
member 9 4表B:
uid name
----- ------
1 aaa
2 bbb
3 zzz
4 ccc
9 ddd
10 eee
11 fff
12 ggg
13 hhh表A的 value 与 表B的 uid 关系。
在查询时想得到如下的结果为: uid name
----- ------
1 aaa
4 ccc
2 bbb
10 eee
9 ddd
3 zzz
11 fff
12 ggg
13 hhh
非常感谢!!
解决方案 »
- mysql记录数错误
- Mysql错误求大牛解答,谢谢~
- mysql连接8小时问题?非常抱歉没分可给
- mysql group by的问题
- select u_name,u_id from (select * from user_info where U_name='bbb') where U_pass='aaa' 不对吗?
- postgresql如何整站备份
- 情况紧急,请大家解答!!!
- mysql 中文输入问题.....热心的帮我解一解......100分敬送
- 请问怎么用odbc把aceess里的数据导到linux下的mysql里?
- 求教:数据查询重复,并显示重复内容跟重复的次数
- mysql 繁体中文乱码
- 这样的sql怎么优化比较好?
order by ifnull(a.`order`,99999999),b.uid;
+------+------+
| uid | name |
+------+------+
| 1 | aaa |
| 4 | ccc |
| 2 | bbb |
| 10 | eee |
| 9 | ddd |
| 3 | zzz |
| 11 | fff |
| 12 | ggg |
| 13 | hhh |
+------+------+
9 rows in set (0.00 sec)
from b left join a on b.uid=a.value
order by a.order,b.uid
from b left join a on b.uid=a.value
order by case when a.name is null then 0 else 1 end,a.order,b.uid
order by if(b.order is null,a.uid,-999999+b.order)