Buen día amigos una consulta:
Como le quito los totales duplicados a los campos T0.“NoDocSum” , T0.“DocTotal” ya que me repite los totales.
SELECT T0."DocNum",
T0."DocDate",
T0."CashSum",
T0."CheckSum",
T0."TrsfrSum",
T0."CardCode",
T0."CardName",
T3."DocNum" ,
T3."DocTotal" AS "Total Factura",
T0."DocTotal" AS "Total Recibo",
T4."SlpName",
T1."SumApplied",
(((T1."SumApplied")/1.13)*0.04) AS "Comisión",
T0."NoDocSum"
FROM ORCT T0
INNER JOIN RCT2 T1 ON T0."DocEntry" = T1."DocNum"
LEFT JOIN ODPI T2 ON T1. "DocEntry" = T2. "DocEntry"
LEFT JOIN OINV T3 ON T1."DocEntry" = T3."DocEntry"
LEFT JOIN OSLP T4 ON T3."SlpCode" = T4."SlpCode"
WHERE T0."DocDate" >= [%1] AND T0."DocDate" <= [%2]