Hello All

I'm developing a warehouse application...

I have following tables

DELIVERIES
Delivery_ID INT
Deliver_Date Date
...

DELIVERIES_ITEMS
ID INT
Delivery_ID INT
Delivery_Refno
Goods_ID INT
Delivery_Qty INT
...

ORDERS
Order_ID INT
Order_Date Date
...

ORDERS_ITEMS
ID INT
Order_ID INT
Goods_ID INT
Order_Qty INT

ORDERS_ITEMS_DELIVERIES
ID INT
Delivery_Item_ID INT
Order_Item_ID INT
Goods_ID INT
Order_Qty
...

Can someone help me constructing the query that will return warehouse stock
for certain day like this:
Goods_ID, Delivery_RefNo, Qty

Maybe the metadata is not sufficient for this..

TIA
Marcin