Combine Active and Archived Orders
Easy
Set Operations
Return all orders from both tables with a source label ('active' or 'archived'), ordered by id.
Table schema
ActiveOrders(id INT, amount INT)
ArchivedOrders(id INT, amount INT)Sample data
ActiveOrders
id | amount
1 | 100
3 | 50
ArchivedOrders
id | amount
2 | 70
4 | 30
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.