title: SQLite regular table and table for fts
body: <p>I have table <strong>news (id, news_id, news_title)</strong> and I creat FTS table: </p>
  
  <pre><code>CREATE VIRTUAL TABLE news_search USING fts4 (news_title, tokenize=porter);
  </code></pre>
  
  <p>I use trigger to keep table NEWS and news_search in sync:</p>
  
  <pre><code>CREATE TRIGGER IF NOT EXISTS insert_news_trigger 
  AFTER INSERT ON news 
  BEGIN 
  INSERT OR IGNORE INTO news_search (news_title) VALUES (NEW.news_title);
  END;
  </code></pre>
  
  <p>Question: how to use search? When I do MATCH in news_search table it returns me only records from this table, but I need *news_id* from <strong>news</strong> table. May be I should add *news_id* column to <strong>news_search</strong> table?</p>
  
  <p>What is the proper way to use fts in sqlite?</p>