joined update

[Anon]

Sorry if I'm overlooking the obvious solution to this, but I can't seem to update a field based on a join.
UPDATE planet_ranks set planet_ranks.rank = planets.rank where (planets.x = planet_ranks.x) AND (planets.y = planet_ranks.y) and howold='0'

is the command that I'd like to use, and I know I need to define the table 'planets' somewhere, but I can't figure out where...

[daus95]

try this:

UPDATE planet_ranks
SET planet_ranks.rank =
(SELECT planets.rank
FROM planets
WHERE
(planets.x = planet_ranks.x AND
planets.y = planet_ranks.y) AND
howold='0'