UNION联合查询

课程:SQL · 编程练习

SQL编程练习 - UNION联合查询

练习内容

-- 合并当前订单和历史订单\nSELECT order_id, user_id, amount, status, created_at\nFROM current_orders\nWHERE status = 'active'\nUNION\nSELECT order_id, user_id, amount, status, created_at\nFROM archived_orders\nW