Încearcă: 

SELECT ISNULL ( (SELECT SUM(valoare) AS test FROM table1 WHERE column3 = 0 AND data <= '2007-09-30' AND column4 = 145214 GROUP BY column4) , 0)