Join ile Update

UPDATE t1
   SET t1.data =
(SELECT t2.data
                FROM  t2
               WHERE t1.a=t2.a
AND t1.b=t2.b
AND t1.c=t2.c
AND t2.d=1
and t2.e='01062012'
AND t1.f=t2.f
AND t1.h=t2.h
--and rownum=1
)
WHERE t1.d=0
AND t1.e='01062012'
and t1.i=0;