In MySQL, how to use a subquery to a left join statement?
===

I tried to count how many new tuples are in a subset of t2 as compared to t1 by


    SELECT
      COUNT(t2.id)
    FROM (
      (SELECT id, col1 FROM t2 WHERE col2=0 AND col3=0) AS t
      LEFT OUTER JOIN
        t1
      ON
        t.id=t1.id
    )
    WHERE
      t1.id IS NULL;

The subset is defined by

    (SELECT id, col1 FROM t2 WHERE col2=0 AND col3=0) AS t

But the above program doesn't seem to work, issuing errors.