Hi,

I have 2 fields, customer number and lifestage (a,b,c). The lifestage can occur more than once.

How do I find customers with lifestage that have duplicates. For eg, customer 5 has 2 lifestage (a and a).

What is the simplest SQl query to acheive this?

Thanks.

Nijojo.