From: tfs@dslextreme.com   
      
   I have a table function that works fine except when used as  a JOIN.   
      
   If I have a function that I am passing a parameter from a value I had gotten   
   from my query:   
      
   SELECT   
                   t1.nID   
   FROM table1 t1   
   JOIN dbo.udf_somefunction(t1.nID)   
      
   I get an error:   
      
   The multi-part identifier "t1.nID" could not be bound.   
      
   This works fine if I change the select as:   
      
   SELECT   
                   t1.nID   
   FROM table1 t1   
   JOIN dbo.udf_somefunction(10)   
      
   How can I get this to work??   
      
   Thanks,   
      
   Tom   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)