Help

[kbreiss]

In the following query in the WHERE statement I have "QNTY ON HAND" being compared to Reorder_Level. My problem is that "QNTY ON HAND" is a column I made up in the SELECT statement by subtracting UNITS_RECEIVED from UNITS_RECEIVED.

SELECT PRODUCTS.PROD_NAME, Sum(UNITS_RECEIVED-UNITS_SHIPPED) AS ["QNTY ON HAND"]
FROM (PRODUCTS INNER JOIN INV_TRANSACTIONS ON PRODUCTS.PROD_ID = INV_TRANSACTIONS.PROD_ID)
WHERE ["QNTY ON HAND"] < Products.Reorder_Level
GROUP BY PRODUCTS.PROD_NAME;


Does anybody have any idea how I could get the product names to return where the "QNTY ON HAND" IS < the products.Reorder_Level?

Thanks in advance,
Kacy
________
Upskirt Pantyhose

 

[FoFa]

You are going to need two subselects I think. One for your qty on hand and one for your reorder level.

 

[kbreiss]

Is there anywhere I could look up stuff on subselects??? I am not familiar with them. Thanks for the advice.

Kacy
________
Toyota 7m-ge specifications