同张表中同时查询两个字段显示一个字段，对两个字段进行按时间排序

select b.bid_name as bidName,bd.repayment_way as depict,r.exact_repayment_time as time,
r.should_repayment_principal as amount, '待收本金' as typeContent
from repayment r
INNER JOIN bid b
ON r.bid_id = b.bid_id
INNER JOIN bid_details bd
ON b.bid_id = bd.bid_id
where r.user_id=1 and r.state = 1
UNION
select b.bid_name as bidName,bd.repayment_way as depict,r.exact_repayment_time as time,
r.should_repayment_interest as amount, '待收利息' as typeContent
from repayment r
INNER JOIN bid b
ON r.bid_id = b.bid_id
INNER JOIN bid_details bd
ON b.bid_id = bd.bid_id
where r.user_id=1 and r.state = 1
ORDER BY time

 

转载于:https://www.cnblogs.com/ccEmma/p/8984270.html