title: How to create a sql view (CREATE VIEW) in sqlite(android) and query?
body: <p>So I have a table and I want to create another table using "CREATE VIEW" from sql.
  I need to make a copy of the table that I am working with so I can use it 2x. My sql query would have to be like this:</p>
  
  <pre><code>SELECT A.time AS Start, B.time AS Stop
  FROM time A, time B
  WHERE A.id+1=B.id
  AND A.bool=1
  AND B.bool=0
  </code></pre>
  
  <p>my initial table is:</p>
  
  <pre><code>    String sql="create table "+TABLE+" ( "+C_ID+" INTEGER PRIMARY KEY AUTOINCREMENT, "
  +C_TIME+" TEXT, "+C_BOOL+" NUMERIC)";
  </code></pre>
  
  <p>so anyone has any ideea where (in my code) I can create the view and how do I query it in android?</p>
  
  <p>I can provide code if needed</p>
  
  <p>Thank you :)</p>