It just hides from MySQL that it's using the same table in the subselect as in the update.