title: Is there a way we can query two tables from two different databases in Google Spanner?
body: <p>I want to query two different tables from two different databases in Google Spanner. I want to do something like this:</p>
  
  <pre><code>SELECT T1.C1
        ,T2.C3
        ,T2.C4
  FROM Database1.Table1 T1 
  INNER JOIN Database2.Table2 T2
  ON T1.C1 = T2.C2
  </code></pre>
  
  <p>However, when I use database name along with the table name (Database.table), I receive an error </p>
  
  <blockquote>
    <p>Table not found: 'Database.table'</p>
  </blockquote>
  
  <p>Is there any other way I can achieve this or the only workaround for this is to create all the tables in the same database?</p>