SELECT GSTJYGL0.SPMC00,GSTKHGL0.KHMC00,XKZH00,TO_CHAR(XSQRRQ,'YYYYMM'),SUM(SL0000)
FROM GSTJYGL0,XSVFXPS0,GSTKHGL0
WHERE GSTJYGL0.SPDM00=XSVFXPS0.SPDM00 AND GSTKHGL0.XKZH00=XSVFXPS0.XKZH00
AND TO_CHAR(XSQRRQ,'YYYY')=2003
GROUP BY GSTJYGL0.SPMC00,XSVFXPS0.XKZH00,TO_CHAR(XSQRRQ,'YYYYMM')
ORDER BY TO_CHAR(XSQRRQ,'YYYYMM'),SUM(SL0000) DESC
第23个字符应为半角",",而不是全角",":
SELECT GSTJYGL0.SPMC00,GSTKHGL0.KHMC00,XKZH00,TO_CHAR(XSQRRQ,'YYYYMM'),SUM(SL0000)
FROM GSTJYGL0,XSVFXPS0,GSTKHGL0
WHERE GSTJYGL0.SPDM00=XSVFXPS0.SPDM00 AND GSTKHGL0.XKZH00=XSVFXPS0.XKZH00
AND TO_CHAR(XSQRRQ,'YYYY')=2003
GROUP BY GSTJYGL0.SPMC00,XSVFXPS0.XKZH00,TO_CHAR(XSQRRQ,'YYYYMM')
ORDER BY TO_CHAR(XSQRRQ,'YYYYMM'),SUM(SL0000) DESC
FROM GSTJYGL0,XSVFXPS0,GSTKHGL0
WHERE GSTJYGL0.SPDM00=XSVFXPS0.SPDM00 AND GSTKHGL0.XKZH00=XSVFXPS0.XKZH00
AND TO_CHAR(XSQRRQ,'YYYY')=2003
GROUP BY GSTJYGL0.SPMC00,XSVFXPS0.XKZH00,TO_CHAR(XSQRRQ,'YYYYMM')
ORDER BY TO_CHAR(XSQRRQ,'YYYYMM'),SUM(SL0000) DESC
第23个字符应为半角",",而不是全角",":
SELECT GSTJYGL0.SPMC00,GSTKHGL0.KHMC00,XKZH00,TO_CHAR(XSQRRQ,'YYYYMM'),SUM(SL0000)
FROM GSTJYGL0,XSVFXPS0,GSTKHGL0
WHERE GSTJYGL0.SPDM00=XSVFXPS0.SPDM00 AND GSTKHGL0.XKZH00=XSVFXPS0.XKZH00
AND TO_CHAR(XSQRRQ,'YYYY')=2003
GROUP BY GSTJYGL0.SPMC00,XSVFXPS0.XKZH00,TO_CHAR(XSQRRQ,'YYYYMM')
ORDER BY TO_CHAR(XSQRRQ,'YYYYMM'),SUM(SL0000) DESC
XKZH00
要怎么样处理???