You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

1234567
  1. SELECT account_number,
  2. account_description
  3. FROM general_ledger_accounts
  4. WHERE NOT EXISTS (SELECT *
  5. FROM invoice_line_items
  6. WHERE general_ledger_accounts.account_number = invoice_line_items.account_number)
  7. ORDER BY account_number;