Jeśli mamy

select ... from ... where zmienna in (select)

Jak zapisać poprawnie i czy się da coś takiego

select ... from ... where (select) in (select)

Wedlug W3C nie:

The IN operator may be used if you know the exact value you want to return for at least one of the columns.

SELECT column_name FROM table_name
WHERE column_name IN (value1,value2,..)