データ抽出が上手くいきません

SELECT            test0.code

FROM              

 (SELECT            code, SUM(suuchi) AS suuchi

   FROM              test

    WHERE             (id = 0)

     GROUP BY      code) AS test0

INNER JOIN

 (SELECT            code, SUM(suuchi) AS suuchi

   FROM              test AS test_1

    WHERE             (id = 1)

     GROUP BY       code) AS test1 

ON test0.code = test1.code AND test0.suuchi = test1.suuchi

SELECT code
  FROM testdb.testtable
 GROUP BY code
HAVING SUM(CASE WHEN id = 0 THEN suuchi ELSE 0 END)
     = SUM(CASE WHEN id = 1 THEN suuchi ELSE 0 END)
;