Using Subquery to get results

Select   Vendors.VendorName,
             Vendors.VendorID
FROM  Vendors
LEFT join invoices ON Vendors.VendorId = Invoices.VendorId
WHERE  invoices.VendorId IS NULL

Tom