How_to_retrieve_data_from_a_single_table/Exec_3_23-C.SQL

SELECT vendor_name,
	   default_account_number AS default_account,
       account_description AS description
FROM vendors v JOIN general_ledger_accounts g
     ON vendors.default_account_number = general_ledger_accounts.default_account_number
ORDER BY default_account, vendor_name;