我有两个名为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
这意味着按日期排序。我怎样才能做到这一点?
试试这个:
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
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句