MySQL Forums
Forum List  »  Newbie

Posted by: Rahsaan Tyler
Date: September 12, 2023 12:46AM

Hello everyone. I am currently in a MySQL class. I am having a hard time following along. It is making it hard to solve the questions I have. I am a visual learner and I just need resources (videos) I could watch besides reading this textbook. Below is the question I have to answer. Below that is where I cam currently stuck at.

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

SELECT account_number, account_description, invoice_id
FROM General_Ledger_Accounts
JOIN invoice_line_items
WHERE account_number
ORDER BY invoice_id

Options: ReplyQuote

Written By
September 12, 2023 12:46AM
September 12, 2023 09:24AM
September 12, 2023 09:57AM
September 12, 2023 10:02AM
September 12, 2023 10:49AM
September 12, 2023 07:30PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.