Write a SELECT statement that returns two columns from the GLAccounts table: AccountNo and AccountDescription. The result set should have one row for each account number that has never been used. Use a correlated subquery introduced with the NOT EXISTS operator. Sort the final result set by AccountNo.

SELECT account_number, account_description

FROM general_ledger_accounts

WHERE NOT EXISTS

(SELECT *

FROM invoice_line_items

WHERE invoice_line_items.account_number = general_ledger_accounts.account_number)

ORDER BY account_number

Explanation:

sry need points : (

i've had the same problem. i generally just ignore it, as a ton of these "verified answers" are completely wrong.