Question: How do I do this query? 6. Write a SELECT statement that returns these three columns: account_number The account_number column from the General_Ledger_Accounts table account_description


How do I do this query?
6. Write a SELECT statement that returns these three columns: account_number The account_number column from the General_Ledger_Accounts table account_description The account_description column from the General_Ledger_Accounts table invoice_id The invoice_id column from the Invoice_Line_Items table Return one row for each account number that has never been used. This should return 54 rows. Hint: Use an outer join and only return rows where the invoice_id column contains a null value. Remove the invoice_id column from the SELECT clause. Sort the final result set by the account_number column. af te v amjaco02_ap Tables V general_ledger_accounts > Columns account_number account_description Indexes Foreign Keys Triggers invoice_archive invoice_line_items Columns invoice_id invoice_sequence account_number line_item_amount line_item_description Indexes Foreign Keys Triggers invoices terms vendor_contacts vendors Views Administration Schemas
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
