Re: inventory management problem

From: Cimode <cimode_at_hotmail.com>
Date: 14 Oct 2006 12:28:00 -0700
Message-ID: <1160854080.305072.93870@h48g2000cwc.googlegroups.com>

prabuinet wrote:

purchase (ItemId, PurchQuantity, PurchaseDate); sales (ItemId, SalesQuantity, SalesDate);

With these two table could I able to find:

1. Quantity in Stock at any given date of any item. YES
2. Purchase and Sales and their OpeningStock and ClosingStock Report Ordered by date YES

You can get both information using good old SQL. Hint: use grouping and join. Received on Sat Oct 14 2006 - 14:28:00 CDT