语法错误,晕半天了
DELECT t1 FROM tdb_goods AS T1 LEFT JOIN(SELECT 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;
DELECT t1 FROM tdb_goods AS T1 LEFT JOIN(SELECT 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;
2017-01-08
举报