Ayuda con esta consulta

[egarcia1980]

EStimados, tengo esta consulta, yo necesito que los valores me aparezcan en un solo campo, siendo mas claros, necesito que los valores comunes sean sumados o restados en una misma columna....

Ayuda por favor.

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]