如何在mysql中使用order获取两个表的详细信息

Question

我有两张桌子叫wsbill和wspay。wsbill用来存储账单细节，wspay用来存储支付细节。我想要创建这两个表的事务详细信息。

我桌子的结构是，

 mysql> select * from wspay;
 +------------+-------+------+
 | WDATE      | NAME  | AMT  |
 +------------+-------+------+
 | 2015-01-28 | Bilal | 2000 |
 | 2015-01-30 | Bilal | 5000 |
 +------------+-------+------+

  mysql> select * from wsbill;
  +------------+---------+-------+------+--------+-------+
  | WDATE      | WSELLER | BILL  | LESS | REASON | FAMT  |
  +------------+---------+-------+------+--------+-------+
  | 2015-01-27 | Bilal   | 11000 | 1000 | test   | 10000 |
  | 2015-01-29 | Bilal   | 12000 | 1000 | test   | 11000 |
  +------------+---------+-------+------+--------+-------+

现在我想要输出，

  2015-01-27  Bilal    11000  1000  test    10000
  2015-01-28  Bilal  2000 
  2015-01-29  Bilal    12000  1000  test    11000
  2015-01-30  Bilal  5000

这意味着按日期订购。我该怎么做？

Answer 1

试试这个：

select *
from (
     select wdate, name, amt, null as less, null as reason, null as famt
     from wspay
     union
     select wdate, wseller, bill, less, reason, famt
     from wsbill
     ) x
order by wdate

Answer 2

   SELECT * from ( select * from table1
   union
   select * from table2 )order by WDATE DESC