> >> > 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

Tss - it actually does, sort of, although I currently get a "no current
record for
fetch operation " - but that might be my Fb version ( WI-T1.5.0.3481
Firebird 1.5
Release Candidate 3)

> I second the idea of CREATE FUNCTION, even though it's only syntactic
> sugar AFAICT.

Disagree - a FUNCTION allows usage without SELECT etc and can be
very much more "clean" in this regard.



With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com