Hi,

> 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

With regards,

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