As title says im getting that error message, I know why im getting it but what is the best work around? Ive tried a few but must be getting the syntax wrong.
SELECT PartNumber, Manufacture, COUNT(PartNumber) as TheCount
WHERE COUNT(PartNumber) > 1
Group BY PartNumber, Manufacture