calling table valued function in select statement

[fikir]

hello every one

I have a table valued function. and trying to use it in a select statement like this

select
(select first_name from tblValuedFunction(per.id) as name
from person

it is generating an error

how can I call a table vaued function in select statemet

Thanks,

 

[fuzzyocelot]

What is the error message you're receiving?

 

[bborissov]

What this function returns?
It should returns TABLE. Can you post the code from your function. Also If that function returns table why not just JOIN the result?

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP