How_to_retrieve_data_from_two_or_more_tables_2/demo-queries-from slides-13.sql

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;