How_to_retrieve_data_from_two_or_more_tables_2/exercise-4.sql

SELECT vendor_name, invoice_date, invoice_number, 
       invoice_sequence AS li_sequence,
       line_item_amount AS li_amount
FROM vendors v JOIN invoices i
  ON v.vendor_id = i.vendor_id
 JOIN invoice_line_items li
   ON i.invoice_id = li.invoice_id
ORDER BY vendor_name, invoice_date, invoice_number, invoice_sequence