Joining tables and create a "LoggedIn" variable if statement matches

So I got two tables. Players and Connections. Each table contains an ID. players.ID and connections.AccountID.

I want to create a query that SELECTS from players and returns "LoggedIn" in a temporary field if the ID exists inside the connections table.

How would I go about that?