以下のSQLクエリは、"game "テーブルをプレーヤーのユーザー名で更新します：

UPDATE game
SET player1_name = (SELECT name FROM user WHERE user.id = game.player1_id)、
    player2_name = (SELECT name FROM user WHERE user.id = game.player2_id)
La siguiente consulta SQL actualizará la tabla "game" con los nombres de usuario de los jugadores:

UPDATE game
SET player1_name = (SELECT name FROM user WHERE user.id = game.player1_id),
    player2_name = (SELECT name FROM user WHERE user.id = game.player2_id)