Subject | Re: How can be stored procedure used in a SELECT |
---|---|
Author | kimon_the_athenian2 |
Post date | 2004-05-27T06:06:32Z |
> select t.id,Thank you Alexander, it's exactly what I was looking for! I only had
> sp.some_calculation,
> sp.related_calculation,
> sp.yet_another_calculation
> from sometable t LEFT join somesp sp(t.id) on 0=0
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