want to see duplicates INNER JOIN

From: AshleyT (anonymous_at_discussions.microsoft.com)
Date: 04/21/04


Date: Wed, 21 Apr 2004 06:06:03 -0700

Below is my query where I want to see duplicate rows, but I don't:

SELECT dbo.tblItemOrder.Itemnumber, dbo.cp_IV00101.ITEMDESC, dbo.tblItemOrder.Quantity
FROM dbo.tblItemOrder INNER JOIN
                      dbo.cp_IV00101 ON dbo.tblItemOrder.Itemnumber = dbo.cp_IV00101.ITEMNMBR
WHERE (dbo.tblItemOrder.Itemstatus = 'okay' and store = '001SS'
GROUP BY dbo.tblItemOrder.Itemnumber, dbo.tblItemOrder.Quantity, dbo.cp_IV00101.ITEMDESC, dbo.cp_IV00101.SELNGUOM
ORDER BY dbo.tblItemOrder.Itemnumber

how can I see those rows as duplicates? It is a working table that I don't have a primary key in, and was hoping not to have to add one. Thanks for any ideas.