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

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