How_to_retrieve_data_from_a_single_table/Exec_3_24-C.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.vendors_id = i.verdors_id 
	 JOIN Invoice_Line_Items li
	 ON i.invoice_id = li.invoice.id
ORDER BY vendor_name, 
         invoice_date, 
         invoice_number, 
         invoice_sequence;