Cacher is the code snippet organizer for pro developers

SELECT * FROM Erp.PartRev 
INNER JOIN (select 
	[PartRev].[PartNum] as [PartRev_PartNum],
	(COUNT (PartRev.PartNum)) as [Calculated_NumofRevs]
from Erp.PartRev as PartRev
 where (PartRev.Approved = 1 AND PartRev.Company = '01500000')
group by [PartRev].[PartNum]
having (COUNT (PartRev.PartNum)) > 1) x ON x.PartRev_PartNum = Erp.PartRev.PartNum

WHERE Company = '01500000' ORDER BY PartNum