as zice ca la sintaxa ...

incearca : UPDATE friends f SET f.imagelocation = ( SELECT rm.imagelocation FROM registered_members rm, friends f WHERE f.imagelocation = rm.imagelocation )