IN

select * from Rating 
where ID_PLAYER in (
    select ID_PLAYER from Players where PLAYER_STATUS = 'Active'
    );

EXISTS

select * from Rating r
where exists (
    select 1 from Players p
    where  p.ID_PLAYER = r.ID_PLAYER and p.PLAYER_STATUS = 'Active'
    );