mysql 兩個表結果合拼到一個表，用常量區別不同的表

select * from (
(SELECT order_amount,org_user_name,createtime,trans_category_id,'1' from  fa_recharge  WHERE org_user_id=1 and (createtime BETWEEN 1655793317 and 1676917369)) 

 UNION ALL

(SELECT order_amount,org_user_name,createtime,wallet_type as trans_category_id,'2'   from  fa_order  WHERE org_user_id=1 and ( createtime BETWEEN 1655793317 and 1676917369)) ) 
 a 

ORDER BY createtime limit 0,10

結果

從圖中可以區分 紅色框的資料是來自 fa_order

本作品採用《CC 協議》，轉載必須註明作者和本文連結