>
>Look, you're turning the original problem into something else
>
>I have said ' I have no time for this'
>I repeat: I won't be answering to you any more in this thread

Greg,

This is the original question.

I have a table like

c1 c2 c3 ...
A a 1
A b 2
A b 3
B c 4
B d 4
A b 3

For a given c3 the combination of c1 and c2 should be the same. We can see that for c3=4 this is not true.

How do I code a single SELECT SQL that returns just

c1 c2 c3
B c 4
B d 4

------------------------
Now, put

c1 c2 c3 ...
A a 1
A b 2
A b 3
B c 4
B d 4
b d 4 && Just add this one line
A b 3

----------------------
We now only want to return B c 4.

This is the problem as I understood it and none of the proposed solutions solve it.

But I think I just figured a solution in my head - and it's not that complex, after all.