select
beijian, ren, sum(lysl), sum(xhsl)
from
(
SELECT lysl.beijian, lysl.ren, lysl.lysl, null xhsl from lysl
union
select xhsl.beijian, xhsl.ren, null lysl,xhsl.xhsl from xhsl
) t
group by beijian, ren
————————————————
版权声明:本文为CSDN博主「人生何處不春風」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/qq_37002981/article/details/125916385
06-29
3770
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
01-13
571
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交