Query to check inventory left

[rcycheng]

Hi all experts,

I am a beginner in database programming. I need to create a query to check the remaining inventory in a company. Here are the tables that i created:

tbl_Inventory_IN
ID - char
QTY - INT
Date - date

tbl_Inventory_OUT
ID - char
QTY - INT
Date - date

I need the query to display a list of items with the remaining quantity. How I can do it??

For example,

tbl_Inventory_IN
ID QTY
A 10
B 5
C 15

tbl_Inventory_OUT
ID QTY
B 3
C 15

Result: (Inventory remain)
ID QTY
A 10
B 2


Please help!!!!!!

 

[NPUser]

quick example

 

[rcycheng]

Thank You Thank You!!!!

Thank You So Much!!!!!!!!!!