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

Yes :-/

>He's simply asking for
> how to do aliasing:
>
> from
> sp1(param1) a
> left join sp1(param2) b
> on a.id = b.id

Well, didn't understand that... I thought he said my
thingy worked:

> > > Thank you, this is what I needed

With regards,

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