where in (select from another table)

Let the client code decide to select from which table inside where in clause.