How_to_retrieve_data_from_two_or_more_tables/exec_5C63.sql

USE AP;

SELECT invoice_number, line_item_amount,
line_item_description
FROM invoices JOIN invoice_line_items line_items
ON invoices.invoice_id = line_items.invoice_id
WHERE account_number = 540
ORDER BY invoice_date