title: joining across databases with sqlite3 / pysqlite
body: <p>I have two separate database files each with tables with matching primary keys, but different data. I want to pull out rows from one table based on values in the other. In the CLI for <code>sqlite3</code>, I would do this like:</p>
  
  <pre><code>.open data.db
  .open details.db
  attach 'data.db' as data;
  attach 'details.db' as details;
  
  select details.A.colA from data.A join details.A using ('key') where data.A.colB = 0 and data.A.colC = 1;
  </code></pre>
  
  <p>How can I recreate such a cross-database join using <code>pysqlite</code>?</p>