SQL

Write a SELECT statement then 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. Sort the final result set by AccountNo. Hint: use an outer join to the InvoiceLineItem table. To code account number that has never been used ---- WHERE InvoiceLineItems.AccountNo IS NULL Here is result set with 54 rows:

Account... AccountDescription 100 Cash 2 110 Accounts Receivable 3 120 Book Inventory 4 162 Capitalized Lease 167 Software 6 181 Book Development 7 200 Accounts Payable 8 206 Royalties Payable 9 221 401K Employee Contributions 10 230 Sales Taxes Payable 11 234 Medicare Taxes Payable 12 235 Income Taxes Payable 13 237 State Payroll Taxes Payable