Consultar stock mediante consulta SQL

[flaviovich]

Código sql:

SELECT SUM(s.cant_ing) - SUM(isnull(v.cant_vend,0)) AS Stock_Fisico
FROM STOCK s
LEFT JOIN VENTA v ON s.producto_id = v.producto_id
WHERE s.producto_id = 17000