12345678910 |
-
- USE AP;
- SELECT 'Active' AS source, invoice_number, invoice_date, invoice_total
- FROM invoices
- WHERE invoice_date >= '2018_06_01'
- UNION
- SELECT 'Paid' AS source, invoice_number, invoice_date, invoice_total
- FROM invoices
- WHERE invoice_date >= '2018_06_01'
- ORDER BY invoice_total DESC;
|