How_to_retrieve_data_from_a_single_table/exer_5C18.sql

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