SELECT C.HY_DM, C.HYMC, MAX ( CASE WHEN XSE.ND = '2021' THEN SUM(XSE.XSE) END ) XSE_2021, MAX ( CASE WHEN XSE.ND = '2022' THEN SUM(XSE.XSE) END ) XSE_2022 FROM HX_DJ.DJ_NSRXX NSRXX --纳税人基本信息 LEFT JOIN HX_DM_QG.DM_GY_HY B ON B.HY_DM = SUBSTR(NSRXX.HY_DM, 1, 2) --判定纳税人行业大类 LEFT JOIN HX_DM_QG.DM_GY_HY C ON C.HY_DM = B.SJHY_DM --判定纳税人行业门类 JOIN (SELECT SBB.DJXH, TO_CHAR(SBB.SKSSQQ, 'yyyy') ND, SUM(NVL(YBNSR.ASYSLJSXSE, 0) + NVL(YBNSR.AJYBFJSXSE, 0) + NVL(YBNSR.MSXSE, 0) + NVL(YBNSR.MDTBFCKXSE, 0)) XSE --分别计算纳税人销售额 FROM HX_SB.SB_SBB SBB, HX_SB.SB_ZZS_YBNSR YBNSR WHERE SBB.SBUUID = YBNSR.SBUUID AND SBB.GZLX_DM_1 <> '2' AND SBB.ZFRQ_1 IS NULL AND TO_CHAR(SBB.SKSSQQ, 'yyyy') IN ('2021' , '2022') --所属期 AND YBNSR.EWBLXH IN ('1', '3') GROUP BY SBB.DJXH, TO_CHAR(SBB.SKSSQQ, 'yyyy')) XSE ON XSE.DJXH = NSRXX.DJXH WHERE NSRXX.YXBZ = 'Y' AND NSRXX.KQCCSZTDJBZ = 'N' AND NSRXX.NSRZT_DM = '03' GROUP BY C.HYMC, C.HY_DM, XSE.ND ORDER BY C.HY_DM 验证以上代码语法错误
时间: 2024-02-14 13:12:53 浏览: 31
以上代码语法没有错误,但是在 `JOIN` 子句中,需要将 `IN` 操作符后面的两个参数之间的中文逗号改为英文逗号。修改后的代码如下:
```
SELECT C.HY_DM,
C.HYMC,
MAX(CASE WHEN XSE.ND = '2021' THEN SUM(XSE.XSE) END) XSE_2021,
MAX(CASE WHEN XSE.ND = '2022' THEN SUM(XSE.XSE) END) XSE_2022
FROM HX_DJ.DJ_NSRXX NSRXX --纳税人基本信息
LEFT JOIN HX_DM_QG.DM_GY_HY B ON B.HY_DM = SUBSTR(NSRXX.HY_DM, 1, 2) --判定纳税人行业大类
LEFT JOIN HX_DM_QG.DM_GY_HY C ON C.HY_DM = B.SJHY_DM --判定纳税人行业门类
JOIN (SELECT SBB.DJXH,
TO_CHAR(SBB.SKSSQQ, 'yyyy') ND,
SUM(NVL(YBNSR.ASYSLJSXSE, 0) + NVL(YBNSR.AJYBFJSXSE, 0) + NVL(YBNSR.MSXSE, 0) + NVL(YBNSR.MDTBFCKXSE, 0)) XSE --分别计算纳税人销售额
FROM HX_SB.SB_SBB SBB
JOIN HX_SB.SB_ZZS_YBNSR YBNSR ON SBB.SBUUID = YBNSR.SBUUID AND YBNSR.EWBLXH IN ('1', '3')
WHERE SBB.GZLX_DM_1 <> '2'
AND SBB.ZFRQ_1 IS NULL
AND TO_CHAR(SBB.SKSSQQ, 'yyyy') IN ('2021', '2022') --所属期
GROUP BY SBB.DJXH, TO_CHAR(SBB.SKSSQQ, 'yyyy')) XSE ON XSE.DJXH = NSRXX.DJXH
WHERE NSRXX.YXBZ = 'Y'
AND NSRXX.KQCCSZTDJBZ = 'N'
AND NSRXX.NSRZT_DM = '03'
GROUP BY C.HYMC, C.HY_DM, XSE.ND
ORDER BY C.HY_DM
```
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)