[AccessD] SQL EXISTS

Don't know about improved, but I tend to use a construct like:

SELECT Customers.CustomerID, Customers.CompanyName
FROM Customers
LEFT JOIN  Orders ON Orders.CustomerID = Customers.CustomerID
WHERE Orders.CustomerID IS NULL

-- 
Stuart

On 23 Oct 2014 at 12:15, Susan Harkins wrote:

> 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.
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>