title: select same table in multiple schema's without using union all
body: <p>Schema Name's: <code>A,B</code></p>
  
  <p>Both schema have same Table :</p>
  
  <p>Table Name: <code>stock</code>. Feilds <code>no,Stname</code></p>
  
  <p>I want retrive details from stock table in two schams.</p>
  
  <p>So i use this query :</p>
  
  <pre><code> select no,stname from A.stock union all select no,stname from B.stock
  </code></pre>
  
  <p>I want to get the tables detail with out union all. Is it possible ? How to do that ?</p>
  
  <p>I am using postgresql 9.0</p>