You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
1234567 |
- use ap;
-
- SELECT vendor_name, MAX(invoice_date) AS latest_inv
- FROM vendors v
- LEFT JOIN invoices i ON v.vendor_id = i.vendor_id
- GROUP BY vendor_name
- ORDER BY latest_inv DESC;
|