My SQL isn't the best. Here's my situation:
My table consists of three fields. I'll call them A, B, and C (for simplicity).
For each A, there should be only one B-C combination. No matter how many times A is in the table, it should always have the same B and C. But, there are some duplicates where A will have a different C or even different Bs AND Cs, which I am trying to find.
Can anyone help me with my MySQL query?