Windows Sql get column value from accounts

[Nekiro]

Hello i have question is it possible to add column name 'account_id' which is getting id from 'accounts' table based on player_id column in my table?
in SQL

Something like return account id from player id

 

[Emky]

--nvm this--

 

[Nekiro]

How to create new table based on number from accounts table and ID column?
Something like players_online table and player_id column. Its receiving player id of player online but i need to receive player account id from player online ;x

like this one player id = 24 and account id = 2 its player table.

 

[Emky]

id from players_online, account_id from players and character name from players

SELECT players_online.player_id as id, players.account_id, players.name FROM `players_online` INNER JOIN `players` ON players_online.player_id=players.id