user defined table question

[junkmail]

I have a user defined table function the returns three columns. Is there a way to reference just one column so I can compare that value to something else or should I just make it a view instead?

 

[bborissov]

SELECT YourTable.*
FROM YourTable
INNER JOIN dbo.YourTableFunction(Parameters) FuncAlias ON YourTable.SomeField = FuncAlias.OneOfTheFields

You just need to ALIAS the function and then start use it as a table


Borislav Borissov
VFP9 SP2, SQL Server

 

[junkmail]

thanks. I will try it out.

 

[junkmail]

It work perfectly! Thanks again for your help.