mysql4.0版本以上可以试试:
(SELECT mess_id,title,time FROM problem ORDER BY time)
UNION
(SELECT mess_id,title,time FROM result ORDER BY time)
ORDER BY time;
(SELECT mess_id,title,time FROM problem ORDER BY time)
UNION
(SELECT mess_id,title,time FROM result ORDER BY time)
ORDER BY time;
解决方案 »
- Duplicate entry 是什么原因?
- 请大虾帮忙解决where查询语句的一个sql
- 紧急求救:今天早上一来打开公司网站时出现:Error: Can't create TCP/IP socket (10106)
- 关于交叉表的问题,并算平均值是怎么写的SQL语句
- [求助]MYSQL 与 CC无法连接
- MySQL Replication 同步的疑惑~!
- Mysql 语法和SQL语法有很大的区别吗?为什么这条在它上面执行不了?
- 【50分】哪里有比较好的mysql资料、教材???
- MySQL跨月表查询方案
- 求助大神作业不会做了,急
- MYSQL安装错误!(小弟刚入门,急求帮助)
- 请问怎样在 mysql -u root -p 命令行直接写password,而不要等提示输入密码再输入
也就是:
select problem.mess_id,problem.title, result.mess_id, result.title from problem,result order by problem.time;#看你用哪个表的时间排序当然也可以为表指定别名,就是cloudchen(陈系上.net)写的。
select a.mess_id,b.time from problem a,result b order by b.time;