Question

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.

Answer 1

Answer:

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: