Posted - 11/28/2009 : 16:44:12
| I need a query to generate a list with the following fields:
Itemcode, Sum(Order.Rowtotal), Sum(Ship.Rowtotal) for the Period > '20091101' And < '20091130' And where Orderstatus = 'C'
From Order Table:
Order.id, Order.Itemcode, Order.Rowtotal, Order.Date, Order.Status
From Ship Table:
Ship.Id, Ship.Baseid (same as Order.id), Ship.Itemcode, Ship.Rowtotal, Ship.Date
Order table includes all orders.
Ship Table only includes records for items that have shipped.
Any help would be appreciated.