MySQL Question

AP Database

Chapter 4 How to retrieve data from two or more tables 4. Write a SELECT statement that returns these five columns: vendor_name The vendor_name column from the Vendors table! invoice_date The invoice_date column from the Invoices table! invoice number The invoice_number column from the Invoices table! li_sequence The invoice_sequence column from the Invoice_Line Items table li_amount The line_item_amount column from the Invoice_Line_Items table Use aliases for the tables. This should return 118 rows. Sort the final result set by vendor_name, invoice_date, invoice_number, and invoice_sequence. 5. Write a SELECT statement that returns three columns: Chapter 4 How to retrieve data from two or more tables 4. Write a SELECT statement that returns these five columns: vendor_name The vendor_name column from the Vendors table! invoice_date The invoice_date column from the Invoices table! invoice number The invoice_number column from the Invoices table! li_sequence The invoice_sequence column from the Invoice_Line Items table li_amount The line_item_amount column from the Invoice_Line_Items table Use aliases for the tables. This should return 118 rows. Sort the final result set by vendor_name, invoice_date, invoice_number, and invoice_sequence. 5. Write a SELECT statement that returns three columns