SQL problem again..

[phpqt]

Table Software:

SoftwareID
SoftwareName
Version
ProductKey
ComputerID

Table Computer:
ComputerId
(more but its not important)

SELECT Software.ProductKey
FROM Software
WHERE (((Software.Version)='2000') AND ((Software.SoftwareName)='Microsoft Office'))
GROUP BY Software.ProductKey
HAVING (((Count(Software.ProductKey))>1));

I get the correct results with the above SQL. It shows me a list of duplicate product keys. However. it only shows me each product key once. I would like to to show each product key the number of times it is used. I would also like to include "ComputerID" beside each product key so I can know which computer is related to the duplicate keys. How do I do this?

[YappyDog]

I don't have any way of testing this, but it should work..........

SELECT Software.ProductKey, Software.ComputerID, Count(*) as PCount
FROM Software, Computer
WHERE Software.ComputerID = Computer.ComputerID
AND Software.Version ='2000'

AND Software.SoftwareName = 'Microsoft Office'
GROUP BY Software.ProductKey, Software.ComputerID
HAVING PCount >1;

Including the ComputerID in the mix may hide some of the results if you leave the HAVING clause in the SQL.

[phpqt]

Thank you, that helped!