--- In firebird-support@yahoogroups.com, Svein Erling Tysvær
<svein.erling.tysvaer@k...> wrote:

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

Ahhhhhhhhhh!!
:) obvious !!

I was fighting wiht

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

what couldn't work of course

>
> HTH,
> Set

thx,
CUIN Kaczy