12345678910111213 |
- SELECT vendor_name,
- invoice_date,
- invoice_number,
- invoice_sequence AS li_sequence,
- line_item_amount AS li_amount
- FROM vendors v JOIN invoices i,
- ON v.vendors_id = i.verdors_id
- JOIN Invoice_Line_Items li
- ON i.invoice_id = li.invoice.id
- ORDER BY vendor_name,
- invoice_date,
- invoice_number,
- invoice_sequence;
|