SELECT vendor_name, invoice_date, invoice_number, invoice_sequence AS li_sequence, line_item_amount AS li_amount FROM vendors v, invoices i, Invoice_Line_Items l ORDER BY vendor_name, invoice_date, invoice_number, invoice_sequence;