Thanks You,
Richard and Alexander Medvedev
:-)
JAMES <harleyip@hotmail.com> wrote in message
news:90o10u$da12@imsp212.netvigator.com...
> I have 3 tables, I want to show current stock quantity for each item.
>
> Table item
> <item_id> <item_name> <cost>
> <selling_price>
> P001 A4 Paper 10 12
> P002 Pen 2
> 3
> P003 Eraser 1
2
> P004 Book 20
25
>
> Table stock_out
> <item_id> <qty> <date>
> P001 4 11-NOV-00
> P002 2 02-NOV-00
>
> Table stock_in
> <item_id> <qty> <date>
> P001 10 01-OCT-00
> P002 10 01-AUG-00
> P003 10 01-JUL-00
> P004 10 01-AUG-00
>
>
> How can I show the following result?
> <item_id> <qty>
> P001 6
> P002 8
> P003 10
> P004 10
>
>
> THANKS
> James
>
>