How_to_retrieve_data_from_two_or_more_tables/exec_5C36.sql

USE AP;

SELECT vendor_id, vendor_name, vendor_state
FROM vendors
WHERE vendor_id NOT IN
    (SELECT DISTINCT vendor_id
    FROM invoices)
ORDER BY vendor_id;