因为数据较多,用了分表
user1
+----+--------+
| id | value |
+----+--------+
| 1 | 2 |
| 2 | 3
+----+--------user2
+----+--------+
| id | value |
+----+--------+
| 3 | 0 |
| 4 | 4
+----+--------现在想用一条语句查询 2张表,并根据value 排序,怎么写? 谢谢!
user1
+----+--------+
| id | value |
+----+--------+
| 1 | 2 |
| 2 | 3
+----+--------user2
+----+--------+
| id | value |
+----+--------+
| 3 | 0 |
| 4 | 4
+----+--------现在想用一条语句查询 2张表,并根据value 排序,怎么写? 谢谢!
union all
select * from user2
order by value
union all
select * from user2
order by 2