-
SQL Help..
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|