SELECT b.BCLID AS BCLID, b.PcbID AS PcbID, b.PN AS PN, b.CompName AS CompName
FROM BomInfo a, BomCompListInfo b
WHERE a.PN = b.PN AND a.PcbID = b.PcbID AND
b.CompName in ( SELECT CompName FROM BomCompListInfo
WHERE PcbID = 80
GROUP BY CompName
HAVING count(*) > 1 )
AND a.PcbID = 80
ORDER BY CompName