Helen, Martijn,

>> > select foo.col1, xy.outputparam
>> > from foo
>> > join xy on foo.col2 = xy.inputparam

>>I've never seen that syntax and according to my
>>Firebird install, it doesn't work either.

This should work instead:

select foo.col1, xy.outputparam
from foo
join someproc(...) xy on foo.col2 = xy.outputparam

I second the idea of CREATE FUNCTION, even though it's only syntactic
sugar AFAICT.
Ciao
--
Nando mailto:nandod@...