UPDATE foo SET bar=bar-1 WHERE baz= ( SELECT baz ... From here: web article "The reason for this ...
stackoverflow.com