SQLQuery查询操作

查询名称和数量，如何把名称去重的情况下把数量相加，例如螺丝刀去重后只显示一个名称数量为200？

SELECT PNAME, SUM(QTY) AS SUM_QTY
FROM SPJ,P
GROUP BY PNAME

如果ok，欢迎点赞

SELECT sum(QTY),PNAME
FROM SPJ
WHERE JNO = 'J2'
GROUP BY PNAME