Firebird Stored Procedure in Select verwenden

[dataspider]

Hi,

SP wie einen SubSelect in Klammern:

Code:

Select c.Name, (select age from Get_Age_For_Customer(c.ID)) as age from Customer c

[EDIT]
Das geht auch und mache ich oft, wenn die SP mehrere Ausgabe - Parameter hat:

Code:

Select c.name
     , a.age from Customer c
       left join Get_Age_For_Customer(c.ID) a on 1 = 1

[/EDIT]
Frank