1234567891011 |
- USE ex;
- SELECT 'Active' AS source, invoice_number, invoice_date, invoice_total
- FROM active_invoices
- WHERE invoice_date >= '2018_06_01'
- UNION
- SELECT 'Paid' AS source, invoice_number, invoice_date, invoice_total
- FROM paid_invoices
- WHERE invoice_date >= '2018_06_01'
- ORDER BY invoice_total DESC;
-
- /* union
|