Subject joining stored procedures results
Author kaczy27

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 *
left join sp2(param2)
on sp1(param1).id = sp2(param2).id

is it possible somehow?

CUIN Kaczy