--- In firebird-support@yahoogroups.com, "Martijn Tonies" wrote:

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

Huh? Have you run out of Bamsemums already??? He's simply asking for
how to do aliasing:

from
sp1(param1) a
left join sp1(param2) b
on a.id = b.id

HTH,
Set