[Firebird-devel] [ firebird-Bugs-422240 ] Left join with stored procedure

[<no...@so...>]

Bugs item #422240, was updated on 2001-05-08 02:22
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=109028&aid=422240&group_id=9028

Category: ISQL
Group: Initial Bug
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Left join with stored procedure

Initial Comment:
We have two stored procedures and want to do 

select *
from proc1('AAA') p1 left join proc2('AAA') p2 on 
(p1.id=p2.id)

if I try to execute this query - server crashes.

----------------------------------------------------------------------

Comment By: mariuz (mapopa)
Date: 2001-05-15 01:20

Message:
Logged In: YES 
user_id=85089

why don't you try to execute the second 
procedure proc2 inside the first one 
so that you do'nt need a join
something like this :

proce1()
...
for select xxx from yyy where xxx="AAA"
do begin 
execute procedure proc2("AAA")...
end 
...

and this way you could pass some parameters to 
the second procedure and return 
from the first proc with values you need



----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=109028&aid=422240&group_id=9028