How_to_code_subqueries/exercise-01.sql

SELECT vendor_name
FROM vendors
WHERE vendor_id IN
     (SELECT DISTINCT vendor_id FROM invoices)
ORDER BY vendor_name