Use JOIN..ON
create a query to display five columns from three tables:
VName ? vendor_name from the Vendors table
INV_Date ? invoice_date from the Invoices table
INV_Number ? invoice_number from the Invoices table
INV_Lsequence ? invoice_sequence from the Invoice_Line_Items table
INV_L_Amount ? line_item_amt from the Invoice_Line_Items table
Use these aliases for the tables: Ven for the Vendors table, Inv for the
Invoices table, and LI for the Invoice_Line_Items table. Also, display
only the records where the invoice_date is between June 1, 2014 and
June 6, 2014. Sort the final result set by vendor_name, invoice_date,
invoice_number, and invoice_sequence.