I need a little help joining a stored procedure which requires an
input parameter.

e.g.

CREATE PROCEDURE FOO (INPARAM1 INTEGER) RETURNS (OUTDATA1 INTEGER)
AS
BEGIN
for
select * from my table where mytable.id = INPARAM1
do
begin
Suspend;
end
END;

So, I am trying to join the aboved stored procedure into another
query.

Select fb.*
From FooBar fb
Inner Join FOO(fb.Table2)