CREATE TABLE TESTTB1(numberid INT ,name CHAR(5),  ckzs INT)
INSERT TESTTB1
SELECT 1,          'A',              5    UNION
SELECT 2,          'B',              0 UNION
SELECT 3,          'C',              11 UNION
SELECT 4,          'D',             0 
CREATE TABLE TESTTB2(recnumber INT,cksl INT)
INSERT TESTTB2
SELECT 1 ,                       1 UNION
SELECT 1  ,                      3 UNION
SELECT 3   ,                     2 UNION
SELECT 1  ,                      2 UNION
SELECT 3  ,                      5 UNION
SELECT 4 ,                       6 


--SELECT * FROM TESTTB1
--SELECT * FROM TESTTB2

SELECT TESTTB1.* FROM TESTTB1,(SELECT RECNUMBER,SUM(CKSL)CKSL FROM TESTTB2 GROUP BY RECNUMBER)AS T
 WHERE TESTTB1.numberid=T.RECNUMBER AND CKZS<>CKSL