Are you sure on Customers.CustID = Orders.OrderID shouldn't be
on Customers.CustID = Orders.CustID ?
The query is below
Also you will probably get a table scan instead of index seek/scan with the date conversions that you are doing
select Customers.EmailAddress, Customers.FirstName
left join Orders
on Customers.CustID = Orders.OrderID
and CAST(CONVERT(char(10), DateAdded, 112) as smalldatetime) >= '11/7/2005'
and CAST(CONVERT(char(10), DateAdded, 112) as smalldatetime) <= '11/8/2005'
where Orders.OrderID is null
âI sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/