开通会员
有一张资金记录表，一张金币记录表，想以时间为单位，降序合并排列他们之间的信息，查询SQL如下：
select * from (select * from t_money_logs union select * from t_gold_logs) as c order by create_time desc;
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;
本文摘自 ：https://blog.51cto.com/u