title: how to Combine two tables column in oracle?
body: <pre>
  Table 1:
  CURRENCY CODE   ER  GUARANTOR ID    G AMOUNT
  USD        1.2986   117          750
  AED        4.76976  117          5750
  ZAR        11.4717  117          234
  INR        70.676   117          1243
  AMD        526.5823 117          500000
  EUR          1  117          12435
  ALL       139.63197 117         2000000
  EUR          1  173         200000
  EUR          1  217         20000000
  INR       70.676    26           100000
  AED      4.76976    43          1000000
  EUR          1  53          10000
  </pre>
  
  <pre>
  Table 2:
  
                       F AMOUNT
  USD     1.2986  117 450
  AED    4.76976  117 7900
  INR     70.676  117 2237.4
  ZAR    11.4717  117 140.4
  AMD   526.5823  117 500000
  EUR          1  117 6961
  ALL  139.63197  117 2000000
  EUR          1  173 20000
  EUR          1  217 14000000
  INR     70.676  26  300000
  AED    4.76976  43  2000000
  EUR          1  53  10000
  </pre>
  
  <pre>
  Result:
  
  CURRENCY CODE   ER  GUARANTOR ID    G AMOUNT       F AMOUNT
  USD        1.2986   117          750             450
  AED        4.76976  117          5750            7900
  ZAR        11.4717  117          234            2237.4
  INR        70.676   117          1243            140.4
  AMD        526.5823 117          500000         500000
  EUR          1  117          12435
  ALL       139.63197 117         2000000
  EUR          1  173         200000
  EUR          1  217         20000000
  INR       70.676    26           100000
  AED      4.76976    43          1000000
  EUR          1  53          10000
  </pre>
  
  <p>I want to combine Both table like i need all the column in table 1 and F AMOUNT column from table 2. how to achieve this?</p>
  
  <p>Thanks in Advance.</p>