Hi

I have a stroed procedure returning sets of foreignkey values
sp1(param1) returning id

and another stored procdures returning greater sets of the same
foreignkey values enhanced with some more params
sp2(param2) returning id, field1, field2

I want to
select *
from
sp1(param1)
left join sp2(param2)
on sp1(param1).id = sp2(param2).id


is it possible somehow?

CUIN Kaczy