SELECT
Sum(OD.ProductQuantity) AS Units,
Sum(O.OrderSubTotal) as OrderSubTotal ,
Sum(O.OrderShippingTotal) as OrderShippingTotal ,
Sum(O.OrderTaxTotal) as OrderTaxTotal ,
Sum(O.OrderTotal) as OrderTotal
FROM
Order_T O
JOIN
Order_Detail_T OD ON O.OrderID = OD.OrderID
WHERE
(OrderDate >= '1/18/2003 00:00:00' AND OrderDate <= '1/18/2003
23:59:59')
This one fails too if I want to display a report based on order id.
SELECT
Sum(OD.ProductQuantity) AS Units,
O.OrderID ,
Sum(O.OrderSubTotal) as OrderSubTotal ,
Sum(O.OrderShippingTotal) as OrderShippingTotal ,
Sum(O.OrderTaxTotal) as OrderTaxTotal ,
Sum(O.OrderTotal) as OrderTotal
FROM
Order_T O
JOIN
Order_Detail_T OD ON O.OrderID = OD.OrderID
WHERE (OrderDate >= '1/17/2003 00:00:00' AND OrderDate <= '1/17/2003
23:59:59')
GROUP BY O.OrderID
Any help would be greatly appreciated.
Thank you,
Jason