I have the following self-join update:
update TABLE set PARENT_ID=parent.PARENT_ID
from TABLE, TABLE parent
where TABLE.PARENT_ID=parent.ID
and parent.ID in (1,2,3,4)
This query is use to update a hierarchy before deleting specific records...
I get the following error:
Table name "table" specified more than once
This appears to be a limitation of the update syntax which is not documented...
Is this something that will be fixed soon? or should I write this query differently?
Any suggestions?
Thanks for your help.
Benoit