converting update sql to oracle

[Nordyck]

Trying to convert this to oracle syntac

Update G081_ELTNHA e set e.NHAPN = e1.PN
inner join G081_ELTNHA e1 on (e.NHACEI = e.CEI and e.NHASN = e1.SN)

Thanks,
Dave

nordycki@hotmail.com

 

[Dagon]

Broadly, the syntax is:

Update G081_ELTNHA e
set e.NHAPN =
(select e1.PN
from G081_ELTNHA e1
where e.NHACEI = e.CEI and e.NHASN = e1.SN )

I can't however comment on whether the update makes much sense. The condition "e.NHACEI = e.CEI" looks pretty suspicious.




For Oracle-related work, contact me through Linked-In.