How_to_retrieve_data_from_two_or_more_tables/exercise-2.sql

SELECT vendor_name, invoice_number, invoice_date,
       invoice_total - payment_total - credit_total AS balance_due
FROM vendors v JOIN invoices i
  ON v.vendor_id = i.vendor_id
WHERE invoice_total - payment_total - credit_total <> 0
ORDER BY vendor_name