SELECT O.CustomerID, O.EmployeeID, O.OrderDate, O.ShipName, O.ShipAddress, OD.ProductID, OD.UnitPrice, OD.Quantity
FROM Orders AS O
INNER JOIN [Order Details] AS OD
ON O.OrderID = OD.OrderID
WHERE (YEAR(O.OrderDate) = 1996 AND
MONTH(O.OrderDate) = 7 AND
DATEPART(DAY, O.OrderDate) BETWEEN 1 AND 15)
GO