How_to_retrieve_data_from_two_or_more_tables/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