Hi

I have a query
select TEL from T_PROSP
where NUM in (select ANUM from StoredProc('A','B','C'))

StoredProc is a procedure with an execute statement

when using select ANUM from StoredProc('A','B','C')) it is done in 0.
03 second, with the query above it takes several minutes (I abort
before end !)

it seems that Firebird execute the stored proc for each value in
T_PROSP

Is there a way to instruct Firebird that the 2 select statement are
independant ?

thanks