aerosolWithColor

SELECT V_ID, V_COLOR, 255 - ISNULL(SUM(B_VOL), 0) AS remaining
FROM utV utV
LEFT JOIN utB utB ON utV.V_ID = utB.B_V_ID
GROUP BY V_ID, V_COLOR
HAVING 255 - ISNULL(SUM(B_VOL), 0) != 0