title: merge two table record in one
body: <p>I have a quetion regarding merge two data table. i have two table Table1 and Table2, In Table 1 there are two column and 10 row and in Table2 there are 5 row and one column. Now i able to find the solution for that how i merge and calulate desired result</p>
  
  <pre><code>Table1
  
  SNO - Name  -  Amount 
  1   -   A   -   10
  2   -   B   -   20
  3   -   C   -   30
  4   -   D   -   40
  5   -   E   -   50
  6   -   F   -   60
  7   -   G   -   70
  8   -   H   -   80
  9   -   I   -   90
  10  -   J   -   100
  
  Table2
  
  Rate(%)  
    20   
    30   
    50   
    60   
    10 
  Now I want result like this
  
  New_Amount Calculation -&gt; (Amount*Rate)/100)
  
     SNO  - Name  -  Amount -  New_Amount 
      1   -   A   -   10    -    2
      2   -   B   -   20    -    6
      3   -   C   -   30    -    15
      4   -   D   -   40    -    24
      5   -   E   -   50    -    20
      6   -   F   -   60    -    12
      7   -   G   -   70    -    21
      8   -   H   -   80    -    24
      9   -   I   -   90    -    54
      10  -   J   -   100    -   10
  </code></pre>
  
  <p>Here <a href="http://sqlfiddle.com/#!3/51519" rel="nofollow"><code>SQLFiddle</code></a></p>
  
  <pre><code>NOte: There no relation between both table
  </code></pre>