Hi All

I have two datatables:
DtCurrency - Consists of one column named currency with different currencies like USD,EUROS,GBP etc..., all values are distinct.

The other datatable dtAllowance consists of two columns Currency and allowance.The rows in this table contain repetitive and different currencies and allowance. Something like this:

CURRENCY | ALLOWANCE
--------------------------
USD 500
USD 690.56
EUROS 400.33
EUROS 444
GBP 399


The rows coming in this Allowance table are dynamic. I need to join currency column of table 2 with that of table 1 and then i need to calculate sum of allowance of each different currencies. How to do this? can someone explain me through code...