title: multiple table result in single query
body: <p>I want to get data from multiple table with single query.
  example :</p>
  
  <p>TABLE-A:</p>
  
  <pre><code>|  LOT  |  ITEM  |  QTY  |
  --------------------------
  |  001  |  PAPER |  20   |
  |  002  |  INK   |  10   |
  |  003  |  PEN   |  25   |
  --------------------------
  </code></pre>
  
  <p>TABLE-B:</p>
  
  <pre><code> |  LOT  |  ITEM  |  QTY  |
   --------------------------
   |  001  |  PAPER |  20   |
   |  002  |  INK   |  10   |
   |  003  |  PEN   |  25   |
   --------------------------
  </code></pre>
  
  <p>TABLE-C:</p>
  
  <pre><code>|  LOT  |  ITEM  |  QTY  |
  --------------------------
  |  001  |  PAPER |  20   |
  |  002  |  INK   |  10   |
  |  003  |  PEN   |  25   |
  --------------------------
  </code></pre>
  
  <p>when I select LOT 001 from all tables, I want the result is :</p>
  
  <pre><code>| TABLE NAME | LOT | ITEM | QTY |
  ---------------------------------
  |  TABLE-A   | 001 | PAPER|  20 |
  |  TABLE-B   | 001 | PAPER|  20 |
  |  TABLE-C   | 001 | PAPER|  20 |
  ---------------------------------
  </code></pre>
  
  <p>Thx for help</p>