How_to_retrieve_data_from_two_or_more_tables/exer_5C12.sql

USE AP;
SELECT vendor_name, invoice_number, invoice_date, account_description, line_item_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
     JOIN general_ledger_accounts ge 
     on li.account_number = ge.account_number
WHERE invoice_total - payment_total - credit_total > 0
ORDER BY vendor_name, line_item_amount DESC;