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 statementthat returns these three columns: account_number The account_number column from the General_Ledger_Accounts

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!