Hi!

I'm having problems with my update below. I know there's a where -clause missing, but I just can't figure out how it should be done properly. I'm stuck with that ORA-01427.

Thanks for advice! OV.

UPDATE apuarea pa SET pa.subarea =
(SELECT pu.subarea FROM prounit pu, popperson pp, popresidence pr
WHERE substr(pr.build inglabel,1, 14) = pu.unitlabel
AND pr.enddate IS NULL
...