How can I use the result of a stored procedure in a select

I wrote a stored procedure which basicaly does :

proc_stor_1 @user_choice as

    select id from table where param = @user_choice

What I want to do is to use the result of proc_stor_1 in a select statement :

select * from table2 where id in ( proc_stor_1)

How can I do it ?

Thanks Received on Fri Apr 28 2000 - 00:00:00 CDT