MySQL两个表联合查询并按时间排序

最新推荐文章于 2024-04-17 14:32:33 发布

拾 -.-

最新推荐文章于 2024-04-17 14:32:33 发布

阅读量2.9k

点赞数 1

文章标签： mysql sql 数据库

本文链接：https://blog.csdn.net/zk86547462/article/details/120646158

版权

有一张资金记录表，一张金币记录表，想以时间为单位，降序合并排列他们之间的信息，查询SQL如下：

select * from (select * from t_money_logs union select * from t_gold_logs) as c order by create_time desc;

原地址：https://www.cnblogs.com/gentsir/p/5166506.html

select * from (select 
o.ORDER_NUM as order_sn,
o.GOODS_NAME as GOODS_NAME,
o.CREATE_TIME as CREATE_TIME,
"goods" as type
from ayy_order o union select 

s.ORDER_NUM as order_sn,
s.GOODS_NAME as GOODS_NAME,
s.CREATE_TIME as CREATE_TIME,
"service" as type
from ayy_service_order s) as c order by CREATE_TIME desc;