Slalom,

> slalom91 wrote:
> >
> > So, I am trying to join the aboved stored procedure into another
> > query.
> >
> > Select fb.*
> > From FooBar fb
> > Inner Join FOO(fb.Table2)
>
> Select fb.*
> From FooBar fb
> Left Join FOO(fb.Table2) On 1 = 1
>
> Dmitry

Although Dmitry is correct, I think you will find this statement will
execute faster (since you wanted an inner join).


SELECT
FB.*
FROM FOO(fb.Table2)
JOIN FooBar FB on FB.ID = FOO.ID


Sean