I was just wondering, what does the 2 mean at the end of this line?
I noticed that when I run a date range search that I have to enter the ending date as the day after from what I really need. For instance, if I am searching 10/12/2010 - 10/13/2010 in order to capture any of the orders on 10/13 date, I have to put it in as 10/14. Any thoughts as to why that might be?
Also, what if I wanted to also display items for that date range in the line AS quantity_sold even if no items were sold?
Here is my query now:
inventory.itemId AS Item_ID,
inventory.itemName AS Item,
inventory.itemDesc AS Description,
inventory.itemSize AS Size,
inventory.itemColor AS Color,
inventory.partNum AS Part_Number,
inventory.prodLine AS Product_Line,
inventory.itemPrice AS Price,
inventory.itemQty AS Quantity_Available,
INNER JOIN inventory
ON orderdetails.DetailItemId = inventory.itemId
INNER JOIN orders
ON orderdetails.DetailOrderId = orders.OrderId
ORDER BY inventory.itemName ASC
Any help would be much appreciated. Thanks!