SELECT
    t.team_Name,
    p1.name + ' ' + p1.surname AS '1st_player_name',
    p2.name + ' ' + p2.surname AS '2nd_player_name'
FROM
    team t
INNER JOIN
    player p1 ON t.player1_id = p1.id
INNER JOIN
    player p2 ON t.player2_id = p2.id