How_to_retrieve_data_from_a_single_table/exer_5C13.sql

USE AP;
SELECT vendor_name, invoice_number, invoice_total
FROM vendors v LEFT JOIN invoices i 
     ON v.vendor_id = i.vendor_id
ORDER BY vendor_name ASC