SELECT gu.user_id,gf.function_id, SUM(gf.add) add, SUM(gf.modify) modify FROM WH_GROUP_USER gu, WH_GROUP_FUNCTION gf WHERE gu.group_id = gf.group_id AND gu.user_id = '000001' GROUP BY gu.user_id, gf.function_id;
select user_id,function_id,max(add),max(modify) from wh_group_user a join wh_group_function b on a.group_id = b.group_id group by user_id,function_id
FROM WH_GROUP_USER gu, WH_GROUP_FUNCTION gf
WHERE gu.group_id = gf.group_id
AND gu.user_id = '000001'
GROUP BY gu.user_id, gf.function_id;
select user_id,function_id,max(add),max(modify)
from wh_group_user a
join wh_group_function b
on a.group_id = b.group_id
group by user_id,function_id