UPDATE self as child, self as parent
SET child.afield = parent.afield
WHERE (child.ParentID = parent.SelfID)
...if that doesn't work, try a subquery?
UPDATE self as child
SET child.afield = (SELECT parent.afield FROM self as parent WHERE parent.SelfID = child.ParentID)