Re: Query problem

I can't get the expected result.
Actually, I have 5 tables,
I am going to find out current stock quantity of each item for current day, sysdate.
Thanks!
James

invoice

invoice_no     staff_name     trans_date
01                  Lancy Lam     23-DEC-00
02                  Tim Hon         02-DEC-00
03                  Jack Wong     11-DEC-00

trans
invoice_no     item_id     qty
01                 P001         1
01                 P002         5
01                 P033         2
01                 P034         1
02                 P022         4
02                 P034         3
02                 P301         1
03                 P001         1

item
item_id     item_name                         cost     selling_price
P001         Unix Training Package     1000     1200
P002         Unix Guide                       100       200
P022         Let us go Europe               100      400
P033         Europe Travel Route         10        100
P034         Europe travel Video Tape 200      300
P301         Unix Installation CD         500     1000

package
package_id     sub_item_id
P001             P002
P001             P301
P022             P033
P022             P034


stock_in
item_id         trans_date             qty
P001             02-JAN-00         15
P002             01-DEC-00         50
P022             05-MAY-00         70
P033             25-SEP-00         50
P034             01-MAY-00         40
P301             12-DEC-99         30
P001             20-DEC-00         10
P034             21-DEC-00         5
P002             17-DEC-00         10