OFFLINE

Suppose I have 1 table having name GL
structure and data of GL table is
GL

srno glcode balance
1       sb     10000
2       ca      20000
3       sbb    2000
4      sbx    1500
and aother table having name GROUPGL
structure and data of GROUPGL table is

srno glname  glcode balance
1      saving
2      current
3     loan

now i have to add
sb,sbx,sbb in GROUPGL filed glcode where gl name is saving and compute
the balnce of thse three gl and add to balance filed of groupgl

output must like this

srno glname             glcode             balance
1      saving              sb,sbx,sbb       13500
2      current              ca                   20000
3     Total deposit                             33500

then what is the query for this type of o/p