TAble 1 DataPK_GL AccountCode AccountName AccountTypeCode FundCode ClassLoadCode Currency Balance BalanceDate1 11000011 Investments-Forward Cash-Unrealized FX GL A IL01 NULL NULL -23426271.27 12/31/20132 11000011 Investments-Futures Contract-Unrealized Price G/L A IL01 NULL NULL 4653508.3499999996 12/31/20133 11000011 Investments-MoneyMarket-Accrued Interest A IL01 NULL NULL 9982.2399999999998 12/31/20134 11000011 Investments-MoneyMarket-Cost A IL01 NULL NULL -707849398.70000005 12/31/20135 11000011 Investments-MoneyMarket-Unrealized FX GL A IL01 NULL NULL 11574347.470000001 12/31/20136 11000011 Investments-Option-Cost A IL01 NULL NULL -86242618.870000005 12/31/2013
table 2 dataPK_ID Section Group Financial Account Description FundCode Balance Date 1 NULL Net Asset Value 2058417061 NULL NULL NULL 2 NULL Total Outstanding shares 2181230039 NULL NULL NULL 3 NULL Net asset value per share 0.94 NULL NULL NULL 4 NULL Net Asset Value for Ignis Absolute Return Government Bond Fund . Class A GBP 23704633.79 Class A GBP NULL NULL 5 NULL Total Outstanding shares for Ignis Absolute Return Government Bond Fund . Class A GBP 20143018.57 Class A GBP NULL NULL 6 NULL Net Asset Value per share for Ignis Absolute Return Government Bond Fund . Class A GBP 1.18 Class A GBP NULL NULL 7 NULL Net Asset Value for Ignis Absolute Return Government Bond Fund. Class I2 GBP 252178460.2 Class I2 GBP NULL NULL
i want to add balance date and fundcode to the second table but sometimes there might be different fundcode for different accounts.is it even possible 
getting data from 1 table into another
Posted - 2014-05-20 : 05:08:40
