title: Joining Keys Issue
body: <p>I am creating HANA View where I have to join two tables and my base table will Table 2 and show Item as per Qty.</p>
  <p>Table 1</p>
  <pre><code>Bill No  | Item    | Qty |
  BILL001  | ITEM001 | 1   |
  BILL001  | ITEM002 | 3   |
  BILL001  | ITEM002 | 2   |
  </code></pre>
  <p>Table 2</p>
  <pre><code>Bill No  |BarCode | Qty |
  BILL001  |BarC01  | 1   | 
  BILL001  |BarC02  | 1   |
  BILL001  |BarC03  | 1   |
  BILL001  |BarC04  | 1   |
  BILL001  |BarC05  | 1   |
  BILL001  |BarC06  | 1   |
  </code></pre>
  <p>Required Result</p>
  <pre><code>Bill No  |BarCode | Qty | Item    |
  BILL001  |BarC01  | 1   | ITEM001 |
  BILL001  |BarC02  | 1   | ITEM002 |
  BILL001  |BarC03  | 1   | ITEM002 |
  BILL001  |BarC04  | 1   | ITEM002 |
  BILL001  |BarC05  | 1   | ITEM003 |
  BILL001  |BarC06  | 1   | ITEM003 |
  </code></pre>
  <p>Important Note - In Table 2 Qty always will be one.</p>
  <p>Thanks</p>