[dba-SQLServer]SP question

Dear group,

is it possible to use the result set of a stored procedure in the where
clause of another SQL-Statement?

Something like:

Select * from MyTable where My_ID in (spMySP) (This does not work...)

The SP returns a couple of ID's (only one column)


TIA,

Michael