Cross reference Demand vs On hand inventory

[L40]

I need help with two queries I have created. The 1^stquerie runs my upcoming orders and shows me what part number will be requirealong with the demand needed. The second query displays my entireinventory with on hand qty. I need to be able to compare the both and have itgive me a report on what part numbers I will be short along with quantities. Itonly needs to give me the part numbers from the 1^st query if my demand is less than my onhand inventory. <o></o>

 

[L40]

Here is some more information, hopefuly it makes sence

.The LPROD is my part number. My qty on hand will be acalculated field that will take (LOPB + LRCT + LADJU) – LISSU which will giveme my QOH (qty on hand). Below is a sample of the two tables.<o></o>
The CHILD field on the 2nd table is my part number and theSumOfQtyRQ is my demand <o></o>
<o> </o>

Current_INVENTORY<o></o>​
LPROD<o></o>​	LWHS<o></o>​	LLOC<o></o>​	LOPB<o></o>​	LRCT<o></o>​	LADJU<o></o>​	LISSU<o></o>​	Expr1<o></o>​
19A24011 <o></o>	02<o></o>	PSSH03<o></o>	230<o></o>​	0<o></o>​	0<o></o>​	0<o></o>​
03E10178 <o></o>	04<o></o>	05042 <o></o>	5<o></o>​	0<o></o>​	0<o></o>​	0<o></o>​
03B11040 <o></o>	04<o></o>	05033 <o></o>	7<o></o>​	0<o></o>​	0<o></o>​	0<o></o>​
54U22088 <o></o>	02<o></o>	17081 <o></o>	2<o></o>​	0<o></o>​	0<o></o>​	0<o></o>​
10J14721 <o></o>	04<o></o>	04053 <o></o>	1<o></o>​	0<o></o>​	0<o></o>​	0<o></o>​
10J14736 <o></o>	04<o></o>	04022 <o></o>	1<o></o>​	0<o></o>​	0<o></o>​	0<o></o>​
08A10052 <o></o>	04<o></o>	10141 <o></o>	1<o></o>​	0<o></o>​	0<o></o>​	0<o></o>​

<thead> </thead> <tbody> </tbody>

<o> </o>
<o> </o>

ScheduledSystemBOM<o></o>​
CHILD<o></o>​	CDESC<o></o>​	CITYP<o></o>​	CSKUM<o></o>​	SumOfCQTYRQ<o></o>​
02P14005 <o></o>	COMP 2DA3R89KL-TFD-C27 <o></o>	R<o></o>	EA<o></o>	8<o></o>​
02P14041 <o></o>	COMP 3DB3R12ML-TFD-C27 <o></o>	R<o></o>	EA<o></o>	40<o></o>​
02P14061 <o></o>	COMP 3DF4S11ML-TFD-C27 <o></o>	R<o></o>	EA<o></o>	20<o></o>​
02P14114 <o></o>	COMP 3DS4S12ML-TFD-C27 <o></o>	R<o></o>	EA<o></o>	52<o></o>​
02P14122 <o></o>	COMP 3DSDS12ML-TFD-C27 <o></o>	R<o></o>	EA<o></o>	40<o></o>​

<thead> </thead> <tbody> </tbody>

<o> </o>

 

[L40]

Sorry correction on the last sentence of my 1st post. It only needs to give me the part numbers from the 1^st query if my demand is mores than my on hand inventory. <o></o>