How_to_retrieve_data_from_two_or_more_tables/exec_5C31.sql

use ap;

SELECT vendor_id, vendor_name, vendor_state
FROM vendors
WHERE NOT EXISTS
    (SELECT *
    FROM invoices
    WHERE vendor_id = vendors.vendor_id);