Subject Re: How can be stored procedure used in a SELECT
Author kimon_the_athenian2
> select t.id,
> sp.some_calculation,
> sp.related_calculation,
> sp.yet_another_calculation
> from sometable t LEFT join somesp sp(t.id) on 0=0


Thank you Alexander, it's exactly what I was looking for! I only had
to rewrite last line like this:

from sometable t LEFT join somesp (t.id) sp on (0=0)

(Actually I did try this way of joining a SP before, but
without "LEFT" and got only errors)

Thanks again!

Aivar