Write a query that shows vendor name, account for all vendors. Account is a single field the combines default account number, a dash, and account description; for example, 200-Accounts Payable. Only use Vendors and general ledger accounts table. Do not give me the same answer you did the last 2 times please. It does not work. SELECT v.vendor_name, CONCAT(gla.default_account_number, '-', gla.account_description) AS account FROM Vendors v JOIN GeneralLedgerAccounts gla ON v.gl_account_id = gla.id; doesnt work