slalom91 wrote:

> 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)
>

Use "Left Join" to force the table to be the first stream to be processed.

try this:

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


see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br