Hi

On some occasions we have wanted to do a multiple join query where we
have also wanted to join the results of a parameterised stored
procedure. However I have never succeeded. I have tried something like

SELECT *
FROM Tablea a
Join Tableb b ON b.id = a.id
etc
JOIN (SELECT * FROM StoredProc(a.id, b.somefield) ) sp ON 1 = 1

This does not work. Could someone enlighten me on the appropriate
syntax to achieve this :)

We have usually resorted to

Select a.id, (select Val1 from StoredProc(a.id, b.somefield)) As Val1,
(select Val2 from StoredProc(a.id, b.somefield)) As Val2
FROM Tablea a
Join Tableb b ON b.id = a.id
etc


However the above seems very inefficient where multiple fields are
required from the stored procedure.


thanks
Rob