Fetch Table-value Functions

Posts   
 
    
csun
User
Posts: 3
Joined: 05-Dec-2007
# Posted on: 07-Mar-2008 02:14:12   

Hi, there

is there any way to fetch a table-value functions? I can see in LLBLGen document Dbfunction section only support Scalar-value functions.

I want to do something like "select field1, field2 from MyTableValuefunction(param1, param2)"

the best would be able to use it as sub-query, like:

select Temp.field1, table1.field2 from table1 inner join (select field1 from myfunction(param1, param2)) as Temp ON table1.field1 = Temp.field1

thanks

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 07-Mar-2008 10:30:10