I want to write a query that would return data if and only if it has all the `ids` that the subquery would return

What I've tried:

```
SELECT * FROM main_table WHERE id IN ( SELECT id FROM sub_table WHERE SOMECODITION)

```

but it returns once it finds at least one matching row in sub query which i do not want.

Mainly I wanna be able to check if the `main_table` has all the `ids` that `sub_table` returns

EDIT:

the `SOMECONDITION` has nothing to do with main query