Jonathan and Henk,

Jonathan Neve wrote:
...snip...

>Select * from table_x x, P_A_OR_B(x.id1,x.id2) p
>Join table_y y on y.id = p.return_value
>
>
>

You make a very good explanation about procedures... :-)

Just a note

Currently in FB you need to use a left join to perform a join with
selectable procedures (as you explained act as a table), something like
this:

Select
*
from
table_x x left join
procedure_y(param1, param2, etc...) y on (x.SomeColumn = y.SomeReturnParameter)

you will get an erros if you try this:
Select
*
from
table_x x join
procedure_y(param1, param2, etc...) y on (x.SomeColumn = y.SomeReturnParameter)


The left join forces the first table to be scanned first.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br