Hi,

I got a group table.

the data in table is

group_id,date,timeframe,available,free

ex.

groupid date t/f avl free
100 20/2 1 5 5
100 20/2 2 4 4
100 20/2 3 2 1

110 20/2 1 3 3
110 20/2 2 4 4
110 20/2 3 5 5

i need the output like this

100 20/2 1 8 8
100 20/2 2 8 8
100 20/2 3 7 6


i need to sum up the available column and free column (merging 110 groupid into 100)


Any help appreciated.

Thanks

SS