title: How to select all columns from multiple SQLite databases
body: <p>I am doing queries over multiple databases in <strong>SQLite</strong>, and I'm having trouble using a .* in my queries. I have successfully used the ATTACH function to reference both databases:</p>
  
  <pre><code>dbOne.execute("ATTACH DATABASE 'dbOne.sql' as db1");
  dbOne.execute("ATTACH DATABASE 'dbTwo.sql' as db2");
  </code></pre>
  
  <p>This query here gives me a syntax error (syntax error near *):</p>
  
  <pre><code>dbOne.execute("SELECT db2.myTable.* FROM db2.myTable");
  </code></pre>
  
  <p>Can I do <code>db2.myTable.*</code>? Or do I have to select each individual column one at a time?</p>
  
  <pre><code>SELECT db2.myTable.columnA, db2.myTable.columnB, db2.myTable.columnC, etc.
  </code></pre>
  
  <p>Thanks!</p>