title: How to Inner Join an UDF Function with parameters using SubSonic
body: <p>I need to query a table using FreeTextTable (because I need ranking), with SubSonic. AFAIK, Subsonic doesn't support FullText, so I ended up creating a simple UDF function (Table Function) which takes 2 params (keywords to search and max number of results).
  Now, how can I inner join the main table with this FreeTextTable?
  InlineQuery is not an option.
  Example:</p>
  
  <p>table ARTICLE with fields Id, ArticleName, Author, ArticleStatus.</p>
  
  <p>The search can be done by one of more of the following fields: ArticleName (fulltext), Author (another FullText but with different search keywords), ArticleStatus (an int).</p>
  
  <p>Actually the query is far more complex and has other joins (depending on user choice).</p>
  
  <p>If SubSonic cannot handle this situation, probably the best solution is good old plain sql (so there would be no need to create an UDF, too).</p>
  
  <p>Thanks for your help</p>
  
  <p>ps: will SubSonic 3.0 handle this situation?</p>