title: SELECTing data from multiples schemas with a JPQL query
body: <p>I have a MariaDB database with 2 schemas : Store1 and Store2. These schemas contain several tables. "Products" is one of these.</p>
  
  <p>In my repository, I need to add the following request :</p>
  
  <pre><code>@Query("SELECT Store1.Products.Id, Store1.Products.Label FROM Store1.Products UNION SELECT Store2.Products.Id, Store2.Products.Label FROM Store2.Products")
  public Page&lt;Products&gt; getAllProducts(Pageable pageable);
  </code></pre>
  
  <p>Of course, the query doesn't work, it's just for an example about what I want to do.
  I've briefly read about multi-tenancy, but I don't know if it fits my use case, and seems complex for such a simple case.</p>
  
  <p>Is there a simpler way to get this query ?</p>