I get a SQLCODE = -206, ERROR: SUM1 IS NOT A COLUMN OF AN INSERTED TABLE
with the following sql statement:
SELECT Y.CTR_NCONTRAT_ENT,
Y.CTR_NCONTRAT_CENT,
Y.CTR_NCONTRAT_DC,
Y.CTR_NCONTRAT_CP,
Y.CTR_NCONTRAT_CTA,
Y.CTR_NCLIENTE,
Z.PRT_NCONTRIB,
Z.PRT_NOME,
Y.CTR_MOEDA,
W.BAS_MLIMRISC,
SUM(CASE X.ORD_IESTFCT WHEN 'GP' THEN X.ORD_MFACTURA
ELSE 0 END) AS SUM1,
SUM(CASE WHEN (X.ORD_IESTFCT = 'FI'
OR X.ORD_IESTFCT = 'IM')
THEN X.ORD_MFACTURA
ELSE 0 END) AS SUM2,
W.BAS_MLIMRISC - (SUM1 + SUM2)
FROM GPBT.FBDTBAS W,
GPBT.FBDTORD X,
GPBT.FBDTCTR Y,
GPBT.FBDTPRT Z
WHERE X.ORD_NCONTRAT_ENT = Y.CTR_NCONTRAT_ENT
AND X.ORD_NCONTRAT_CENT = Y.CTR_NCONTRAT_CENT
AND X.ORD_NCONTRAT_DC = Y.CTR_NCONTRAT_DC
AND X.ORD_NCONTRAT_CP = Y.CTR_NCONTRAT_CP
AND X.ORD_NCONTRAT_CTA = Y.CTR_NCONTRAT_CTA
AND X.ORD_IESTFCT IN ('FI','IM','GP')
AND Y.CTR_NCLIENTE = Z.PRT_NCLIENTE
AND Y.CTR_MOEDA = Z.PRT_MONEDA
AND Y.CTR_NCONTRAT_ENT = W.BAS_NCONTRAT_ENT
AND Y.CTR_NCONTRAT_CENT = W.BAS_NCONTRAT_CENT
AND Y.CTR_NCONTRAT_DC = W.BAS_NCONTRAT_DC
AND Y.CTR_NCONTRAT_CP = W.BAS_NCONTRAT_CP
AND Y.CTR_NCONTRAT_CTA = W.BAS_NCONTRAT_CTA
AND Z.PRT_NCONTRIB = W.BAS_NCONTRIB
AND W.BAS_CCLIENTE = 'C'
GROUP BY Y.CTR_NCONTRAT_ENT,
Y.CTR_NCONTRAT_CENT,
Y.CTR_NCONTRAT_DC,
Y.CTR_NCONTRAT_CP,
Y.CTR_NCONTRAT_CTA,
Y.CTR_NCLIENTE,
Z.PRT_NCONTRIB,
Z.PRT_NOME,
Y.CTR_MOEDA,
W.BAS_MLIMRISC;
But whitout select the last column:
W.BAS_MLIMRISC - (SUM1 + SUM2)
the sql works fine.
How is the simplest way to include the value of the last column in this stament?
