Francisco H Tapia
my.lists at verizon.net
Mon Mar 1 18:47:02 CST 2004
I wrote a quick function that kicks data out in a table format..
example select * from dbo.udfMyFunction ('GUID - 36 char')
which kicks out for example Field1, Field2, Field3 etc...
I wanted to join it to another table...table1 where table1 has Field1
wich could be used as an input parameter for the function, am I thinking
of this wrong?
This errors out for me on the input parameter
Select f1.Field1, f1.Field2, t1.Field3 FROM Table1 AS T1
INNER JOIN dbo.udfFunction1 (T1.Field1)
ON T1.Field1 = F1.Field1
the error occurs at T1.Field1...
any ideas?
--
-Francisco