-2
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

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

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

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?

Thanks in Advance.

lc.
  • 113,939
  • 20
  • 158
  • 187
Stephen L
  • 351
  • 2
  • 6
  • 18

1 Answers1

0

use the below query

select t1.CURRENCY CODE 
       , t1.ER 
       , t1.GUARANTOR 
       , t1.ID 
       , t2.FAMOUNT 
from table1 t1 
    , table2 t2    
where t1.CURRENCY CODE=t2.CURRENCY CODE
APC
  • 144,005
  • 19
  • 170
  • 281
Kalaiarasan Manimaran
  • 1,598
  • 1
  • 12
  • 18