java - mybatis中如何写mysql的union all 查询？

Question

用mybatis如何写下边的sql？

select order_union.* from 
(select order_id, uid, amount, pay_type, pay_time time,'2016' ,'支付' as order_type from fl_pay_order where uid=1001639998 and status=1
UNION ALL 
select order_id, uid ,amount , null as pay_type, pay_time time ,'2017','提现' as order_type from fl_withdraw_order where uid=1001639998 and status=3)
as order_union
order by order_union.time desc limit 0,10

Answer 1

uid=1001639998およびstatus=1のfl_pay_orderからorder_id、uid、amount、pay_type、pay_time time、'2016'、order_typeとして'支付'を選択します
UNION ALL
pay_type、pay_timeとしてorder_id、uid、amount、nullを選択しますtime、'2017' を y、'提现' を order_type (fl_withdraw_order から) (uid=1001639998、status=3)

Answer 2

リーリー