How_to_code_subqueries/exercise_1.sql

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