Necesito sumar o restar en un mismo campo los datos de esta consulta.
Ayuda...
SELECT T0.[DocDate], T0.[CardCode], T1.[CardName], SUM(T0.[DocTotal]) AS TOTAL_VENTA FROM OINV T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode WHERE T0.[DocDate] >=[%0] AND T0.[DocDate] <=[%1] GROUP BY T0.[DocDate], T0.[CardCode], T1.[CardName]
union
SELECT T2.[DocDate], T2.[CardCode], T3.[CardName], SUM(-T2.[DocTotal]) AS TOTAL_VENTA FROM ORIN T2 INNER JOIN OCRD T3 ON T2.CardCode = T3.CardCode WHERE T2.[DocDate] >=[%0] AND T2.[DocDate] <=[%1] GROUP BY T2.[DocDate], T2.[CardCode], T3.[CardName]
