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.