Elmar Haneke wrote:

> how can I join the result of an selectable procedure with the data of
> an table (or perhaps another procedure)?

The same way you join tables. Either use JOIN keyword or WHERE clause.

select ...
from some_table t
left join some_selectable_procedure p on p.foo = t.foo
where...

or

select ...
from some_table t, some_procedure p
where t.foo = p.foo
...

If procedure has input parameters, supply the values:

select ...
from some_table t
left join some_selectable_procedure(bar) p on p.foo = t.foo
where...

etc.

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org