subselect in SQL

SELECT * FROM Whatever WHERE myKey IN (SELECT myKeyReference FROM SomethingElse WHERE YetAnotherThing = 42)