sql="update TTQ_signstatus set waitsso=et.empsso,waittitle=et.titleid,inittime='"&now()&"' from ttq_signstatus s, tta_emptitle et,tta_processnode p where et.empssotitleid='"&empssotitleid&"' and s.popno='"&popno&"' and p.nodeid=s.nodeid and p.formid=s.formid and p.processid="&processid
set waitsso=(select et.empsso from tta_emptitle et where et..empssotitleid='1340' ),
waittitle=(select et.titleid from tta_emptitle et where et.empssotitleid='1340' ),
inittime=sysdate
where s.popno='20070621042'
and s.nodeid = (select s.nodeid from tta_processnode p
where p.nodeid=s.nodeid
and p.formid=s.formid
and p.processid=111)
update table1 t1
set col1 = :val
where exists
(select 1 from tt1 where t1.id = tt1.id and ....)
and exists
(select 1 from tt2 where t1.id = tt2.id and ...)
and exits
(....)