sql to find all the day not avilable in table
===

in sql :i have a problem i want to write a query for this problem:

write a query to shows the day in august 1997 on which there were no any order placed ...i am able to find the date on which the order made but how can i find the day on which no any order were placed?please help me its urgent

by this query it shows the day on which order were placed

SELECT o.OrderID,day(o.OrderDate) AS 'Date' ,sup.CompanyName FROM Orders o INNER JOIN OrderDetails od ON o.OrderID=od.OrderID INNER JOIN Products p ON od.ProductID=p.ProductID INNER JOIN Suppliers sup ON p.SupplierID=sup.SupplierID WHERE sup.CompanyName='Tokyo Traders' AND o.OrderDate BETWEEN '1/1/1997' AND '1/31/1997'