SQL多表汇总字段合并查询

最新推荐文章于 2024-05-26 06:56:15 发布

myl0197

最新推荐文章于 2024-05-26 06:56:15 发布

阅读量2k

点赞数

分类专栏：计算机文章标签： sql join null

本文链接：https://blog.youkuaiyun.com/myl0197/article/details/6181067

版权

计算机专栏收录该内容

35 篇文章

订阅专栏

"SELECT nsrxx.nsrsbh, nsrxx.nsrmc," +
                                   "(CASE WHEN younum >= 0 THEN younum ELSE 0 END) AS younum,(CASE WHEN fpnum >= 0 THEN fpnum ELSE 0 END) AS fpnum," +
                                   "round(younum /fpnum,2) ," +
                                   "swjg FROM (nsrxx LEFT JOIN (SELECT nsrsbh, SUM(sl) AS younum FROM youprkdj where rq between '" + dt1 + "' and '" + dt2 + "' GROUP BY nsrsbh) youprkdj ON nsrxx.nsrsbh = youprkdj.nsrsbh )" +
                                   " LEFT JOIN (SELECT nsrsbh, SUM(sl) AS fpnum FROM zengzsfpxx where rq between '" + dt1 + "' and '" + dt2 + "'" +
                                   " GROUP BY nsrsbh) zengzsfpxx ON nsrxx.nsrsbh = zengzsfpxx.nsrsbh" +
                                   " LEFT JOIN (SELECT swjgdm, swjg FROM dm_swjg) swjgmc ON LEFT(nsrxx.swjgdm," + FormMain.swjgYxws + ") = '"
                                   + FormMain.stSwjgdm.Substring(0, FormMain.swjgYxws) + "' and LEFT(swjgmc.swjgdm," + FormMain.swjgYxws + ") = '"
                                   + FormMain.stSwjgdm.Substring(0, FormMain.swjgYxws) + "' where swjg is not null";