Duplicate Fields - A CHALLENGE !!

Hi

Im trying to find out if any duplicate descriptions exist within one area_key.The following sql does this.

select description,area_key
from items
group by description,area_key
having count(*) > 1

I also need to return the item_no from items for the records returned from the above sql. This field is always unique and therefore the count(*) > 1 will return nothing if item_no is just added to this statement.

Many thanks in advance

Gareth Received on Fri Sep 10 1999 - 03:11:01 CDT