mysql> DELETE t1 FROM tdb_goods AS t1 LEFT JOIN (SELECT MIN(goods_id),goods_name FROM tdb_goods GROUP BY goods_name HAVING count(goods_name) >= 2) AS t2 ON t1.goods_name = t2.goods_name WHERE t1.goods_id > t2.goods_id;
ERROR 1054 (42S22): Unknown column 't2.goods_id' in 'where clause'

上面是语句和出错，请问要怎么解决？