(Solved) : 6 Write Select Statement Returns Three Columns Accountnumber Column Generalledgeraccounts Q29224454 . . .
This is from Murach’s MySQL 2nd Edititon (pages 146-147)
6. Write a SELECT statement that returns these three columns: The account_number column from the General_Ledger_Accounts table The account_description column from the General_Ledger_Accounts table The invoice_id column from the Invoice_Line_Items table account number account_description invoice_id 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. Show transcribed image text
Expert Answer
Answer to 6 Write Select Statement Returns Three Columns Accountnumber Column Generalledgeraccounts Q29224454 . . .
OR