mysql> DELECT t1 FROM tdb_goods AS t1 LEFT JOIN (SELECT goods_name,goods_id 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 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELECT t1 FROM tdb_goods AS t1 LEFT JOIN (SELECT goods_name,goods_id FROM tdb_go' at line 1