No SQL Server, funciona perfeitamente, só que no Oracle 11G

[leandrolbsParticipante]

Tente assim amigo:

update e440ipc A
set A.cstpis = ’71’
where exists (
select * from e440nfc B, e075pro C, e022clf D
where D.codclf = C.codclf
and A.codpro = C.codpro
and B.codemp = A.codemp
and B.codfil = A.codfil
and B.codfor = A.codfor
and B.codsnf = A.codsnf
and B.numnfc = A.numnfc
and B.datent >= ’01/04/2011′
and D.tripis = ‘N’
)