当前位置:首页>正文
两张表相同字段求和的SQL
2024-01-11 16:55:49 互联网 未知
两张表相同字段求和的SQL?
select coalesce(a.name,b.name), coalesce(a.dm,b.dm), sum(isnull(a.age b.age,0))from a full join b on a.name=b.name and a.dm=b.dmgroup by coalesce(a.name,b.name), coalesce(a.dm,b.dm)