Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

user defined table question

Status
Not open for further replies.

junkmail

Programmer
Jan 7, 2001
134
US
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?
 
Code:
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
 
It work perfectly! Thanks again for your help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top