語法錯誤，暈半天了
?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;
1 回答
舉報
0/150
提交
取消
2017-01-08
DELETE 打錯了吧