I'm trying to do:
update nodes n1 set n1.parent_id=(select n2.id from
nodes n2 where n2.key=n1.parent_id);
To set parent_id to the id of the parent (rather than
the key). Would UPDATE FROM fromlist work? I couldn't
find any examples of it's use.
TIA,
CSN
__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html