[AccessD] SQL EXISTS

Susan Harkins ssharkins at gmail.com
Thu Oct 23 11:15:28 CDT 2014


Have there been any enhancements to Jet SQL or Access that would improve on
using NOT EXISTS subquery to find parent records with no related records in
a specific child table?

SELECT Customers.CustomerID, Customers.CompanyName
FROM Customers
WHERE NOT EXISTS (SELECT * FROM Orders WHERE Orders.CustomerID =
Customers.CustomerID)

Susan H.


More information about the AccessD mailing list