Problema con consulta de ventas y pagos...

[Joch_pa]

prueba con lo siguiente :

Código SQL:

SELECT 
    V.fecha AS [Fecha]
    , V.nroFactura AS [Numero Factura]
    , V.neto-D.Haber AS [Debe]
    , D.Haber AS [Haber]
    , V.neto AS [Neto]
FROM Ventas V
INNER JOIN 
    (
    SELECT d.id_venta
        , SUM(d.monto) AS Haber
    FROM  Deudas d
    GROUP BY d.id_venta
    ) D
ON V.id_venta = D.id_venta AND V.saldada=0
 
ORDER BY nroFactura