SQLite query to return all rows that were returned in subquery

Query:

select name,id from player join player_ability on player=id where ability = (select ability from player_ability where player=2)

My subquery returns X and Y.

My main query will match all rows that contains either X or Y, or both.

How can I make sure that the rows my main query returns have X and Y