prabuinet schrieb:
> I have two tables:
>
> 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.
> 2. Purchase and Sales and their OpeningStock and ClosingStock Report
> Ordered by date
What are opening and closing stock reports?
And is this a homework assignment? You sure go about it like if it is.
Volker
--
For email replies, please substitute the obvious.
Received on Sat Oct 14 2006 - 13:08:11 CDT
