title: How to concatenate a selection of sqlite columns spread over multiple tables?
body: <p>I am aware that you can concatenate multiple columns within a single table with a query like this:</p>
  
  <pre><code>SELECT ( column1 || column2 || column3 || ... ) AS some_name FROM some_table
  </code></pre>
  
  <p>Is it possible to concatenate <strong>columns</strong> from <strong>multiple tables</strong> with a <strong>single sqlite query</strong>?</p>
  
  <p>Very simple example -  Two tables and the result:</p>
  
  <pre><code>        Table1              |           Table2          |         Result
    Col1          Col2        |            Col3           |
   -------------------------------------------------------------------------------
     A             B          |             C             |           ABC
  </code></pre>
  
  <p>If this is possible, what would the query be?</p>
  
  <p>I can always manually concatenate multiple single table concatenation results, but having sqlite do all the work would be great:)</p>