Need help with query - inventory

[nightangel73]

I would like to make a query that calculates quantity at hand of a product. I have a product table and other table that records the amount of product removed with it's orderID. The problem I have is if no product has been removed, that is if there is no orders I can't get those records in the query. I only get in the query only the records where there is associated orders.

In the end quantity at hand is the quantity stored minus what has been withdrawn + amount that is returned.

If nothing has been withdrawn then quantity at hand is therefore just the quantity stored.

I would like this inventory query to show me quantity at hand for all products.



I'll appreciate help!

[orange]

Please read this material from Allen Browne.
Good luck.

[ranman256]

You want an OUTER JOIN.
Show ALL recs in 1 tbl and some items in the other (when they exist)

The arrow comes from the table with ALL items, and points to the table with 'some' items.

[nightangel73]

You want an OUTER JOIN.
Show ALL recs in 1 tbl and some items in the other (when they exist)

The arrow comes from the table with ALL items, and points to the table with 'some' items.

That worked out thanks! I edited the joint type and now it does show me all the records.