Outerjoin and Assign values to the column level

[#1]

I am loading the data from 2 different tables

Table1
DocumentNo	Item	Material	Qty
1150044791	10000	xxx	1
1150044791	20000	xyz	1
1150044791	20001	zxc	2
1150044791	30000	yyy	2
1150044791	40000	zzz	1
1150044791	40001	xzz	1

Table2
DocumentNo	Item	StartDate
1150044791	0	1/9/2009
1150044791	20001	12/9/2001

If the item has value 0 then I have to assign the StartDate value 1/9/2009 to the below items

10000

20000

30000

40000

40001

Expecting Result :
DocumentNo	Item	Material	Qty	StartDate
1150044791	10000	xxx	1	1/9/2009
1150044791	20000	xyz	1	1/9/2009
1150044791	20001	zxc	2	12/9/2001
1150044791	30000	yyy	2	1/9/2009
1150044791	40000	zzz	1	1/9/2009
1150044791	40001	xzz	1	1/9/2009

Outerjoin I can join both tables .How can I pickup the startdate value from the item 0 and assign the start date values to the below corresponding items

10000

20000

30000

40000

40001

.

Advance Thanks for your help.

[#2]

Hi,

Herewith i have attached a application for your reference.

regards

Rajesh

[#3]

Thanks a lot for your support and help.