title: How can I create the virtual table using FTS in SQLite
body: <p>How can I create the <strong>virtual table using FTS in SQLite.</strong> </p>
  
  <p>I have 3 tables, but I don't want to add the columns manually into the table.  </p>
  
  <p>For example: I have the 3 tables<br>
   like: <code>t1(t1_id,t1_name)</code>, <code>t2(t2_id,t2_name)</code>, <code>t3(t3_id,t1_id,t2_id,t3_name)</code></p>
  
  <p>Now, I want to create virtual table in which I  want to give only t3 and 
  the columns in t1 and t2 should automatically map into the virtual table. </p>
  
  <p>The expected output should be:-</p>
  
  <pre><code> virtualTable(vt1,t3_id,t3_name,t2_id,t2_name,t1_id,t1_name)
  </code></pre>
  
  <p>I refer <a href="http://www.sqlite.org/fts3.html" rel="nofollow">this</a> and <a href="http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex" rel="nofollow">this</a> links, but I didn't find the solution for my question</p>