Ayuda con esta consulta

[egarcia1980]

Esta es la consulta
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]

Mi resultado es este:

DocDate CardCode CardName Total_Venta
03/11/2009 88888 Clientes Varios -520
03/11/2009 88888 Clientes Varios 1000

Yo lo que quiero tener como resultado es una sola fila donde me sume o reste los datos.

Espero haberme explicado.

Saludos.