Ayuda urgente select

[Cesar_Balaguer]

SELECT coalesce(K.CantCompra,0) as CantCompra, coalesce(S.Producto.'') as Producto, coalesce(S.Stock,0) AS SaldoAnt, coalesce(K.CantVenta,0) as CantVenta, Coalesce(K.CantCompra,0) + Coalesce(S.Stock,0) - Coalesce(K.CantVenta,0) AS StockFinal
FROM dbo.SALDOS AS S LEFT JOIN
dbo.KardexMensual AS K ON S.Producto = K.Producto