How_to_retrieve_data_from_two_or_more_tables/demo-queries-from slides-8.sql

SELECT vendor_name, invoice_number, invoice_total
FROM vendors LEFT JOIN invoices
    ON vendors.vendor_id = invoices.vendor_id
ORDER BY vendor_name;