Update based on values from other index

Hi All,
Can anyone tell me how can I update a field in an index based on a query from another index?
In SQL it should be something UPDATE a SET a.x =(SELECT b.y FROM b WHERE b.z = a.z) WHERE a.w = "somevalue".
Thanks,
Peter

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.