--不知道你需要下面的哪个? select id , v1 = sum(v1) from t1 group by id select id , v2 = sum(v2) from t2 group by idselect t1.id , v1 = sum(v1) from t1,t2 where t1.id = t2.id and t1.v1 = t2.v2 group by t1.id select t1.id , v1 = sum(v1) from t1,t2 where t1.id = t2.id and t1.v1 <> t2.v2 group by t1.id select t2.id , v2 = sum(v2) from t1,t2 where t1.id = t2.id and t1.v1 <> t2.v2 group by t2.id
说不定人家要的是这个 汇总分组=先汇总再分组? select ID,聚集函数(V2) TV2 from ( select * from T1 union all select * from T2 ) a group by ID
select t1.id , v1 = sum(v1) from t1 left join t2 on t1.id = t2.id and t1.v1 <> t2.v2 group by t1.id
select id , v1 = sum(v1) from t1 group by id
select id , v2 = sum(v2) from t2 group by idselect t1.id , v1 = sum(v1) from t1,t2 where t1.id = t2.id and t1.v1 = t2.v2 group by t1.id
select t1.id , v1 = sum(v1) from t1,t2 where t1.id = t2.id and t1.v1 <> t2.v2 group by t1.id
select t2.id , v2 = sum(v2) from t1,t2 where t1.id = t2.id and t1.v1 <> t2.v2 group by t2.id
select ID,聚集函数(V2) TV2 from (
select * from T1
union all
select * from T2
) a
group by ID
from t1
left join t2
on t1.id = t2.id and t1.v1 <> t2.v2
group by t1.id