Форум пользователей MySQL

Please return one row per vendor, which represents the vendor's oldest invoice (the one with the earliest date).
## Each row returned should include the following columns:
##
##  - "vendor_name" table t1
##  - "invoice_number" table t2
##  - "invoice_date" table t2
##  - "invoice_total" table t2

t1.vendor_id = t2.vendor_id
##
## Please sort the result set by "vendor_name" in ascending order.

СП