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,
- (SELECT MAX(invoice_date) FROM invoices
- WHERE vendor_id = vendors.vendor_id) AS latest_inv
- FROM vendors
- ORDER BY latest_inv DESC;
|