|
|
Posted by Joel on 08/25/05 00:01
Hi,
I'm writing an Sql Statement to total the sale of an order
TotalSale=(TotalSale + (QtyShipped * Price)). I have the syntax & it works
great.
However, I'd like to add Tax + Freight that is derived from another table.
How do I get it to add only once.
Here's the Statement:
"Select Orders.`Order_#`, Orders.`Cust_#`, Orders.`Name`, Orders.Date,
Orders.Status, Orders.`Po_#`, Sum(Olitems.Qty_Shipped * Olitems.Price) As
Total_Sale From Orders, Olitems Where Orders.`Order_#` = Olitems.`Order_#`
Group By Orders.`Order_#` Order By Orders.`Order_#` "
Olitems=Line Item Table
Orders=Header Table
I'd like to include:
Sum((Olitems.Qty_Shipped * Olitems.Price) + Orders.Tax + Orders.Freight) As
Total_Sale
When I do that it keeps on adding tax & freight for each line item! How to
work around that?
Thanks for all your help.
Navigation:
[Reply to this message]
|