> > > 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
> >
> > I think you need to write:
> >
> > on SP1.ID = SP2.ID
>
> Thank you, this is what I needed (actually if the fields are
> different I can use straight join ... on id1 = id2)
>
> and how to code such case
> from
> sp1(param1)
> left join sp1(param2)
> on sp1(param1).id = sp1(param2).id
> ??

Sorry, I don't understand your question.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com