Way of connecting tables

Question

Friends i have a problem...

i have 3 tables...

CREATE DATABASE STORE_TEST;

USE STORE_TEST;

CREATE TABLE ITEM

(

item_id int,

item_name varchar(50),

available_qty int,

added_date datetime,

CONSTRAINT PK_ITEM PRIMARY KEY (item_id)

);

CREATE TABLE STOCK_IN

(

in_id int,

in_item_id int,

in_qty int,

in_date datetime,

CONSTRAINT PK_STOCK_IN PRIMARY KEY (in_id),

CONSTRAINT FK_STOCK_IN FOREIGN KEY (in_item_id) REFERENCES ITEM (item_id)

);

CREATE TABLE STOCK_OUT

(

out_id int,

out_item_id int,

out_qty int,

out_date datetime,

CONSTRAINT PK_STOCK_OUT PRIMARY KEY (out_id),

CONSTRAINT FK_STOCK_OUT FOREIGN KEY (out_item_id) REFERENCES ITEM (item_id)

);

i want to select item_id ,item_name, sum of out_qty,sum of in_qty and available_qty  

in a specified date period.
How can i do it..
Please help me..

Thank you