有一张资金记录表，一张金币记录表，想以时间为单位，降序合并排列他们之间的信息，查询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;