How_to_retrieve_data_from_a_single_table/Exec_3_26.sql

SELECT account_number,
       account_description,
       invoice_id
FROM invoice_line_items i LEFT OUTER JOIN general_ledger_accounts g
ON i.account_number = g.account_number
WHERE invoice_id = NULL
ORDER BY g.account_number ASC;